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

How to test SQL -911 error while developing COB-DB2 program

6697


What is copy pending and check pending in db2?

568


What are the contents of a dclmgen?

621


What are iseries servers?

558


Is db2 a mainframe database?

558






Explain about open switch business continuity software?

554


What is a trigger in the db2 database?

588


On which levels locks can be applied?

650


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3110


How do I add a column to a table in db2?

612


What is the information associated with sysibm.syslinks table?

648


How do I delete a column in db2?

669


What is the difference between using bind () and rebind () methods of naming class?

780


Explain about rct.

639


What's The Percentage Free Space ?

757