how to delete perticular row from table
for ex. how you will delete 3rd row from table
please answer
THANKS IN ADVANCE
Answer Posted / anjireddy vintha
delete from tablename where rownum=3
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is phantom read in db2?
What is a buffer in memory?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
i want to maintain uniqueness on pdf without make lf??????????
What is the clustering index in the db2 database?
How is a typical db2 batch pgm executed?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is bind and rebind in db2?
Describe major components of db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is package in db2 mainframe?
Is ibm db2 free?
Can you tell me how can you find out the # of rows updated after an update statement?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?