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 the picture clause of null indicator variable?

694


What is copy pending status in db2?

638


What is lock escalation in db2?

576


What kind of database is db2?

576


What is nvl in db2?

630






What is a plan and package in db2?

627


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

723


What is a dbrm in db2?

580


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

10782


What is db2 command?

586


How to view db2 table structure?

597


How to connect to db2 database from windows command line?

564


Explain correlated sub-queries.

589


When the like statement is used?

640


Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

628