how to delete perticular row from table
for ex. how you will delete 3rd row from table
please answer
THANKS IN ADVANCE

Answer Posted / anjireddy vintha

delete from tablename where rownum=3

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define buffer pool.

706


What is the meaning concurrency in the db2 database?

735


What is release/acquire in bind?

733


Explain what are the various isolation levels possible?

675


Explain about rct.

744






How do I add a column to an existing table in db2?

678


What is the role of union all and union

727


What is a buffer in memory?

684


Explain package in db2 and its advantages?

699


What is query_cache_limit?

628


What are the bind parameters ibm db2?

708


How do you pull up a query which was previously saved in qmf?

777


List some fields from sqlca?

682


What is the difference between nvl and coalesce?

684


How do you stop a db2 database in linux?

640