i want to delete 20th million record how ?
Answers were Sorted based on User's Feedback
Answer / rajesh
Hope this will do.
delete from tbname where rowcount(*) = 200000 ;
Is This Answer Correct ? | 8 Yes | 2 No |
Answer / sxion045
CREATE VIEW RR(A,B,X) AS
SELECT R.*, ROW_NUMBER()
FROM R;
DELETE FROM RR
WHERE X=20000000;
Is This Answer Correct ? | 2 Yes | 0 No |
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.
Eg.
delete from (
select row_number() over() as row_num from
TEST.TABLE_TEST )
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 |
Answer / 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 |
what is difference between Plan and Package
what is difference between random and sequence file access
what needs to be done if a table is in copy pending / check pending status?
What is REORG? When is it used?
What is phantom read in db2?
what is difference between Static call and Dynamic call? How does it function?
When do you use the IMAGECOPY?
How is the value function used?
Are view updateable?
How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?
what is plan? is plan executable or package?
What is a db2 cursor?