Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

i want to delete 20th million record how ?

Answers were Sorted based on User's Feedback

i want to delete 20th million record how ?..

Answer / rajesh

Hope this will do.

delete from tbname where rowcount(*) = 200000 ;

Is This Answer Correct ?    8 Yes 2 No

i want to delete 20th million record how ?..

Answer / sxion045

WHERE X=20000000;

Is This Answer Correct ?    2 Yes 0 No

i want to delete 20th million record how ?..

Answer / ratheesh nellikkal

Hi All,

I don't think RR and ROWCOUNT works in DB2 for LUW.
So you could go for another option.
Row_number() Over() function you can use for this puspose.

delete from (
select row_number() over() as row_num from
where row_num=20000000;

where TEST is my schema name and
TABLE_TEST is my test table.

Cheers Guys.
Ratheesh Nellikkal

Is This Answer Correct ?    0 Yes 0 No

i want to delete 20th million record how ?..

Answer / magesh

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

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More DB2 Interview Questions

how to check the table is empty or not?

3 Answers   IBM,

What are the disadvantages of PAGE level lock?

3 Answers  

What will happen, while trying to close the closed cursor.

1 Answers  

List down the data types in the db2 database.

0 Answers  

I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?

4 Answers  

How would the varchar column remarks defined?

0 Answers  

How to design maps

1 Answers   Virtusa,

What is the meaning concurrency in the db2 database?

0 Answers  

What is catalog database in db2?

0 Answers  

How would you find out the total number of rows in a db2 table?

0 Answers  

What is declare cursor?

0 Answers  

Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?

1 Answers