Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete perticular row from table
for ex. how you will delete 3rd row from table
please answer
THANKS IN ADVANCE
- 10 Answers
- 15026 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / dalwinder singh
delete from (SELECT * FROM (SELECT col1,rownumber() over()
as rn from table where col =value) as tr where rn = 3)
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
How to view db2 table structure?
what is the role of the cursor in db2?
Where do you specify them?
What are union and union all?
Where can you declare a cursor in a cobol-db2 program?
What is check constraint. Explain with example.
What do you mean by storage group (stogroup)?
What are the 2 sqlcodes that are returned?
What is innodb buffer pool?
Can you tell me how can you find out the # of rows updated after an update statement?
What is catalog database in db2?
How to rename a table in DB2 ?
What is the use of with ur in db2?
Can one database have multiple instances?
What is rebind in db2?
