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

5 Answers
9476 Views
EDS, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do we specify index to include or not during bind process.

2177

What's The Percentage Free Space ?

1284

what is a corelated subquerry?

1170

what is the role of the cursor in db2?

1112

What is cobol db2?

1046

What os does db2 run on?

1048

What is image copy in db2?

1072

What is the latest version of ibm db2?

1338

How do I delete a table in db2?

1124

Mention the various locks that are available in db2.

1086

How to test SQL -911 error while developing COB-DB2 program

7671

How do I delete a table in database?

1079

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1788

What is db2 bind process?

1292

How do I add a column in db2?

1090