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 syntax for creating a table in the db2 database?

633

What is a dbrm in db2?

584

Before you give the explain statement, what are the prerogatives?

590

What is the information associated with sysibm.syslinks table?

668

How many databases can be created inside an instance in db2 ?

609

What is load replace in db2?

565

How to find primary key of a table in db2?

621

Explain the contents that are a part of dclgen.

663

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

637

Define buffer pool.

636

What is null value in db2?

575

Comment whether the cursor is closed during commit or not.

682

What is db2 bind process?

766

How can record locking be achieved in those DB2 versions which do not support it?

630

can we view the access paths created by dbrm ? how ? thx

6277