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

How does db2 sample database connect?

975

Mention the various locks that are available in db2.

976

Define db2.

1067

Why do we bind in db2?

1143

How to get the ddl of a table in db2?

1074

What is cobol db2?

935

What is the reason behind not using select * in embedded sql programs?

1047

What are the prerogatives?

1015

How is the value function used?

1081

Define declaration generator (dclgen).

1068

Mention data types used in db2 ?

1109

How does cobol compile db2 program?

1008

What is cloudant database?

1034

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1230

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

1086