i want to delete 20th million record how ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by cursor?

575


What is db2?

727


What is the role of union all and union

640


What is cursor stability in db2?

796


How to find schema of a table in db2?

558






Comment whether the cursor is closed during commit or not.

656


What is db2 catalog database?

570


Which isolation level provides highest data integrity?

586


is it compulsory commitment control in journal?

2000


Which component is responsible for db2 startup and shutdown?

617


What type of database is db2?

517


What is the connection string to connect to the DB2 Database ?

602


Define db2.

654


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

6211


Explain dclgen.

712