CREATE VIEW RR(A,B,X) AS SELECT R.*, ROW_NUMBER() FROM R; DELETE FRO

i want to delete 20th million record how ?

Question Posted / sxion045

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

Please Help Members By Posting Answers For Below Questions

What is the role of data manager in the db2 database?

649

What is db2 look?

580

How would the varchar column remarks defined?

639

What is the syntax for creating a table in the db2 database?

628

What language is db2 written in?

595

What is runstats utility in db2?

569

What is drop table?

584

What does db2 mean?

589

What is a storage group (stogroup)?

778

How do I copy a table in db2?

575

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

719

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

581

What's The Percentage Free Space ?

773

How do I delete a column in db2?

680

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

630