Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5 Answers
- 9283 Views
- EDS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mithlesh
delete from table_name
where address = '456' and '678'.
| Is This Answer Correct ? | 10 Yes | 4 No |
Answer / 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 |
Answer / suv
We can use concept of cursor to delete particular row. The
row where the cursor is pointing will get deleted.
Please correct is wrong..
| Is This Answer Correct ? | 0 Yes | 1 No |
I think better to perform this in following 2 queries
1. Select count(WS-COUNT) from TABLE;
2. DELETE FROM TABLE WHERE ROWCOUNT(*) IS WS-COUNT OR
(WS-COUNT-1);
Basically here the first row will give you the record count
and 2nd will delete the last and the 2nd last row.
| Is This Answer Correct ? | 0 Yes | 2 No |
Can you define an Index if the table size less than 10 PAGES?
What is package versioning? Please give an example.
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
what is a corelated subquerry?
What is the function of the Data Manager?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How would one remove old reorg information from the DB2 catalog?
What is the clustering index in the db2 database?
How is the SUBSTR keyword used in sql?
what is Runstats? Whem will u choose to runatats?
Which are the db2 tools to protect integrity of the database?
Explain about rct.
COBOL 
