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 the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1270

Can you use max on a char column?

1091

What is difference between rollback and commit?

1153

How do I connect my db2 database to ibm?

1042

What is ibm db2 used for?

1068

How do I copy a table in db2?

994

What type of database is db2?

965

Mention data types used in db2 ?

1152

What is dbrm?

1100

What do you mean by cursor?

988

How does coalesce work?

1010

List out the three types of page locks that can be held.

1145

How do I optimize a query in db2?

1095

What is the clustering index in the db2 database?

998

What is copy pending status in db2?

1117