how to delete perticular row from table
for ex. how you will delete 3rd row from table
please answer
THANKS IN ADVANCE
- 10 Answers
- 12743 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
Explain correlated sub-queries.
What is the maximum size of a char data type in db2?
What is package in db2 mainframe?
What is data manager?
How can deadlocks be resolved?
What are bind parameters in db2?
What is the result of open cursor statement?
Why do we bind in db2?
Where do you specify them?
What are iseries servers?
What is the purpose of rollback and commit?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is ibm db2 used for?
What is the cobol picture clause of the db2 data types date, time, timestamp?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
