how to delete perticular row from table
for ex. how you will delete 3rd row from table
please answer
THANKS IN ADVANCE
Answer Posted / avi
When you are saying row no 3 , means your data is in sorted format and table having the primary key , so find the row no 3 primary key information and then delete it using the where clause with primary value .
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is difference between alias and synonym in db2?
What is check constraint. Explain with example.
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What are catalog tables in db2?
What is ibm db2 connect?
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 ?
Which component is responsible for processing sql statements and selecting access paths?
When do you specify the isolation level?
How to execute stored procedure in db2 command editor?
What is buffer pool?
Explain the benefits you can get from mainframe connect?
What are the various isolation levels possible?
What is null indicator in cobol db2?
Explain the contents that are a part of dclgen.
What do you mean by between and in? Is between inclusive of specified range values?