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
- 15332 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
What are union and union all?
Why select is not preferred in embedded sql programs?
What is the max length of sqlca?
What is declare cursor?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
How do I delete a column in db2?
List some fields from sqlca?
What is cursor in dbms?
What is null indicator in cobol db2?
What do you mean by cursor?
What is the difference between oracle and db2?
When reorg is used?
What's The Error Code For Unique Index Voilation?
What is load utility in db2?
What is db2 catalog database?
