how to delete perticular row from table
for ex. how you will delete 3rd row from table
please answer
THANKS IN ADVANCE
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
What is image copy in db2?
What is performance tuning db2?
What is buffer pool in the db2 database?
What is node in db2?
Explain about rct.
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
How do I start db2 in windows?
Explain various types of locks in db2?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What are bind parameters in db2?
What is db2 plan table?
Name the various locking levels available?
What is multi row fetch in db2?
Is db2 a database?
What is a db2 tablespace?