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


Please Help Members By Posting Answers For Below Questions

What is difference between alias and synonym in db2?

726


What is check constraint. Explain with example.

729


Is it possible to create an Instance in DB2 using DB2 Control Center ?

713


What are catalog tables in db2?

685


What is ibm db2 connect?

652






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 ?

1919


Which component is responsible for processing sql statements and selecting access paths?

764


When do you specify the isolation level?

688


How to execute stored procedure in db2 command editor?

630


What is buffer pool?

728


Explain the benefits you can get from mainframe connect?

614


What are the various isolation levels possible?

737


What is null indicator in cobol db2?

675


Explain the contents that are a part of dclgen.

743


What do you mean by between and in? Is between inclusive of specified range values?

769