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
How do I delete a table in db2?
Explain the benefits you can get from mainframe connect?
What is plan in cobol db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
How many databases can be created inside an instance in db2 ?
If I have a view which is a join of two or more tables, can this view be updateable?
What is performance tuning db2?
What is cursor in dbms?
What is coalesce in db2?
How to execute stored procedures?
What is the maximum No of rows per page?
What does db2 stand for?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
B37 abend during spufi?
What is a bind in db2?