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 the physical storage length of date data type?

1256

What are foreign keys in db2?

1108

How do you select a row using indexes in db2?

1138

How do I start db2 in windows?

1104

How do you eliminate duplicate values in db2?

1198

What is runstats and reorg in db2?

1307

What is the role of union all and union

1129

How can deadlocks be resolved?

944

How would you find out the total number of rows in a db2 table?

1055

What is bind plan?

1054

What db2 400?

1203

What are db2 objects?

1052

What is the picture clause of null indicator variable?

1138

How to execute stored procedure in db2 command editor?

1052

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

1161