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
- 14936 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 is a db2 cursor?
What is a db2 package?
What is ibm db2 used for?
What is database reorganization?
What is the clustering index in the db2 database?
Is db2 a database?
What is check constraint in db2?
What are types of indexes?
How do we specify index to include or not during bind process.
Define sqlca.
Why do we use cursor?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
How is a typical db2 batch pgm executed?
What is db2 plan table?
