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
- 9322 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 |
Write a query to retrive partial string.
Explain package in db2 and its advantages?
Explain the EXPLAIN statement?
how can u understand the end of the table ?
What is an instance in db2?
What techniques will be used to avoid deadlock??
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.
what is difference between Plan and Package
What are the different types of base tables?
What is view db2?
How can record locking be achieved in those DB2 versions which do not support it?
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
COBOL 
