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

i have a table like this :
Name ADDRESS
Toto 123 ...
Toto 456
ToTo 678

I would like to delete 2 last row...please tell me how to
delete its

Question Posted / prashant shettar

Answer Posted / prashant shettar

delete from (select rownumber() over() as rowid from tab1 )
where rowid = ( (select count(*) from tab1) - 1)

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is dclgen (declaration generator)?

1059

How to find schema of a table in db2?

1016

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

2045

What is explain in db2?

1022

What is scrollable cursor in db2?

1055

On which levels locks can be applied?

1133

What does runstats do in db2?

1119

What is the difference between spufi and qmf?

1132

How to find the number of rows in a db2 table?

1120

How is deadlock resolved?

1147

What is null value in db2?

1026

What is a buffer in memory?

1058

Explain the contents that are a part of dclgen.

1092

What is the advantage in De-normalizing tables in DB2?

1179

What is drop table?

1011