How will you delete a particular row from a Table?

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

Can a table contain multiple primary key’s?

705


what are the differences between char and varchar? : Sql dba

631


What is the difference between the conventional and direct path loader? : aql loader

750


Does view contain data?

697


Explain the purpose of %type and %rowtype data types with the example?

641






What is the usage of sql functions?

660


How to know the last executed procedure?

689


Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

789


Which function is used to return remainder in a division operator in sql?

690


what are the 'mysql' command line arguments? : Sql dba

743


Is ms sql traffic encrypted?

595


What are the advantages of pl sql?

720


What is pl sql code?

678


How do I edit a stored procedure?

641


what is the difference between join and union? : Sql dba

637