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

1066

What is drop table?

960

Define db2 and its databases?

1006

what are bind concepts in db2 cobol?

1036

What is multi row fetch in db2?

988

What is the syntax for FETCH in DB2 ?

1141

Define predicate?

1069

What is blu acceleration in db2?

1016

What is reorg and runstats in db2?

1147

How can record locking be achieved in those DB2 versions which do not support it?

1021

What is dpf in db2?

1050

What is db2 look?

971

What do you mean by between and in? Is between inclusive of specified range values?

1041

When reorg is used?

1073

What is the role of data manager in the db2 database?

1053