delete from table where primarykey/uniquekey

How will you delete a particular row from a Table?

Question Posted / priya

7 Answers
16498 Views
Cap Gemini, I also Faced
E-Mail Answers

Answer Posted / priya

delete from table where primarykey/uniquekey_columnname
= 'something';

I hope it will delete a desired particular row.

But if you want to delete a 100th row or something like
that answer will be different

Is This Answer Correct ?

3 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how to run 'mysql' commands from a batch file? : Sql dba

1120

What are the types of queries in sql?

1086

What is online transaction processing (oltp)?

1017

what are sequences

1748

What is PL/SQL Records?

1189

what is rollback? : Sql dba

1111

How do you write an inner join query?

953

What is an escape character in sql?

1027

How many types of normalization are there?

966

what are the type of locks ? : Sql dba

966

What are the types of sql commands?

1103

What is clustered and nonclustered index in sql?

944

How is use pl and sql?

1063

Explain two easy sql optimizations.

1013

how to create a new table in mysql? : Sql dba

986