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 advantage in De-normalizing tables in DB2?

1182

What is a bind card?

1222

What is alias in db2?

1066

What is universal database?

1074

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1049

What does db2 mean?

1021

How do you pull up a query which was previously saved in qmf?

1154

What is ibm db2 client?

944

What is database alias db2?

1132

What are foreign keys in db2?

1108

What is the role of schema in the db2 database?

1278

What are the different types of base tables?

1099

What is host variable?

1063

What is the role of union all and union

1129

Explain about rct in db2?

1113