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

i want to delete 20th million record how ?

Question Posted / rajesh

4 Answers
10926 Views
IBM, I also Faced
E-Mail Answers

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 type of database is db2?

957

What is the maximum size of a char data type in db2?

997

What is db2? Explain.

1023

What is multi row fetch in db2?

1030

What is netezza database?

1003

What is host variable in db2 cobol?

1060

What is sqlca?

1053

What is iseries database?

1037

List some fields from sqlca?

1042

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

1012

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

8248

What is the difference between spufi and qmf?

1106

What are the contents of dclgen?

1091

What does db2 stand for?

997

What is phantom read in db2?

1139