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 nvl in db2?

1150

How can you do the explain of a dynamic sql statement?

1110

What are catalog tables in db2?

1106

How do we specify index to include or not during bind process.

2176

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2911

What is blu acceleration in db2?

1129

What is the syntax for creating a table in the db2 database?

1150

How do you eliminate duplicate values in db2?

1268

What is a db2 schema?

1297

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

1315

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

2268

How to check sequence on a table in db2?

1117

How to take backup of table in db2?

1121

What is runstats and reorg in db2?

1362

What is a bind card?

1278