Example: Delete from STUDENTDETAILS where StudentID = 101

How to delete particular value in the column of a table.Is
it possible or not?if possible give it as in query.

Question Posted / suresh.s

Answer Posted / suresh.s

Example:
Delete from STUDENTDETAILS where StudentID = 101

Is This Answer Correct ?

20 Yes

82 No

Please Help Members By Posting Answers For Below Questions

What are sparse columns?

586

What is the difference between mysql and mysqli?

587

How can you insert values in multiple rows using one Insert statement?

623

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

593

Explain about service Broker functions?

617

Describe in brief sql server monitoring ways.

591

What are user-defined functions (udfs) in sql server?

575

What is an entity-relationship diagram (erd)?

592

What is normalization? What number of normalization shapes are there?

611

Why we should not use triggers?

544

How to read data in a table with "select" statements?

565

Is it safe to delete log files?

527

Tell me about pre-defined functions of sql?

696

How can sql server instances be hidden? : sql server security

599

What is #temp and @table variable in SQL server?

589