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

What is thread join () in threading?

548


what is a constraint? Tell me about its various levels. : Sql dba

566


Can you inner join the same table?

534


What are hotfixes and patches?

537


What is crud diagram?

519






What packages(if any) has oracle provided for use by developers?

5041


what is top in tsql? : Transact sql

553


what is the difference between blob and text? : Sql dba

533


Is sql an operating system?

547


what are aggregate and scalar functions? : Sql dba

557


How do I sort a table in sql?

603


Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

1694


What are the two parts of design view?

587


what does it mean to have quoted_identifier on? : Sql dba

683


What is rank () in sql?

541