delete from (select rownumber() over() as rowid from tab1) where rowid =3

how to delete perticular row from table
for ex. how you will delete 3rd row from table
please answer
THANKS IN ADVANCE

Question Posted / prashant shettar

Answer Posted / prashant shettar

delete from (select rownumber() over() as rowid from tab1)
where rowid =3

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is phantom read in db2?

1136

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1139

What is the maximum size of a char data type in db2?

995

On which levels locks can be applied?

1111

What is database alias db2?

1105

What is the use of db2 optimizer?

1087

Is db2 a mainframe?

1026

How to check table size in db2 sap?

1013

Comment whether the cursor is closed during commit or not.

1081

B37 abend during spufi?

1444

How many types of page locks can be held in db2?

1021

what is db2 restart?

2135

What are concurrency issues?

1074

What is a plan and package in db2?

1086

What is rebind in db2?

1037