delete from (select row_number() over() as COLUMN1 from TABLE

i want to delete 20th million record how ?

Question Posted / magesh

Answer Posted / magesh

delete from (select row_number() over() as COLUMN1 from
TABLE_OWNER.TABLE_NAME )
where COLUMN1=20000000;

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

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

624

What is the difference between plan and package in db2?

579

How do I delete a table in database?

599

What is an instance database?

602

What is cloudant database?

643

What is ibm db2 connect?

574

What is a db2 cursor?

626

What is load utility in db2?

668

Which command is used to remove all rows from a table?

553

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

1715

B37 abend during spufi?

982

What is query_cache_limit?

545

How to get the ddl of a table in db2?

679

What is a db2 schema?

764

What are the uses of db2 optimizer?

818