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 is the difference between db2 and oracle?

1135

What is a db2 package?

1065

How do I copy a table in db2?

1003

What is release/acquire in bind?

1110

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1076

What is host variable in db2 cobol?

1081

Define predicate?

1140

What is cascading rollback?

1219

What is role in db2?

1110

How to restart a DB2 program?

1908

What's The Percentage Free Space ?

1227

What is the use of dclgen in db2?

1085

What is the difference between cursor stability and repeatable read isolation levels?

1182

What are bind parameters in db2?

1050

What is netezza database?

1032