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

10 Answers
14624 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / prashant shettar

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

Is This Answer Correct ?

2 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1310

Comment whether the cursor is closed during commit or not.

1040

What is the maximum length of sqlca?

1432

What is coalesce in db2?

1055

Explain what are the various isolation levels possible?

989

What are host variables in db2?

991

Can you tell me how can you find out the # of rows updated after an update statement?

1044

How do I add a column in db2?

997

Differentiate between cs and rr isolation levels? Where do you specify them?

1022

Which component is responsible for processing sql statements and selecting access paths?

1071

What is innodb buffer pool?

977

What's The Error Code For Unique Index Voilation?

1153

What is the difference between bind and rebind in db2?

1392

How to rename a table in DB2 ?

1030

Is schema the same as database?

1005