i want to delete 20th million record how ?

Answer Posted / rajesh

Hope this will do.

delete from tbname where rowcount(*) = 200000 ;

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is cobol db2?

546


What is view db2?

601


How does cobol compile db2 program?

588


What is node in db2?

589


What is the physical storage length of date data type?

695






Which are the db2 tools to protect integrity of the database?

663


Define data page.

607


What is the difference between drop table and delete table?

530


What is cursor with hold option in db2?

591


What is schema in db2?

559


what is db2 restart?

1666


How many types of page locks can be held in db2?

574


How to take backup of table in db2?

579


Define predicate?

619


Mention the downsides of page level lock.

682