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 the picture clause of null indicator variable?
What is copy pending status in db2?
What is lock escalation in db2?
What kind of database is db2?
What is nvl in db2?
What is a plan and package in db2?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is a dbrm in db2?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is db2 command?
How to view db2 table structure?
How to connect to db2 database from windows command line?
Explain correlated sub-queries.
When the like statement is used?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?