how to delete perticular row from table
for ex. how you will delete 3rd row from table
please answer
THANKS IN ADVANCE
Answer Posted / prashant shettar
delete from (select rownumber() over() as rowid from tab1)
where rowid =3
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Explain in brief how does db2 determine what lock-size to use?
What are iseries servers?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Mention the various locks that are available in db2.
What is rct?
what is the responsibility of the construction superintendent
Why do we need reorg in db2?
What is nvl in db2?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is db2 instance?
Is it possible using max on a char column?
How to create db2 table in mainframe?
what is the role of the cursor in db2?
What is the difference between db2 and oracle?
What is a bind card?