Hope this will do. delete from tbname where rowcount(*) = 200000 ;

i want to delete 20th million record how ?

Question Posted / rajesh

Answer Posted / rajesh

Hope this will do.

delete from tbname where rowcount(*) = 200000 ;

Is This Answer Correct ?

8 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What's The Error Code For Unique Index Voilation?

653

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

714

What is catalog database in db2?

646

Explain in detail about buffer manager and its functionalities?

564

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1709

What is db2 and what is the use of db2 optimizer?

654

What is the default page size of buffer pools?

650

What is the maximum length of sqlca?

869

What kind of database is db2?

572

Is db2 a programming language?

606

If I have a view which is a join of two or more tables, can this view be updateable?

694

How do you find the maximum value in a column in db2?

650

What is dpf in db2?

666

On which levels locks can be applied?

659

Which component is used to execute the sql statements?

621