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


Please Help Members By Posting Answers For Below Questions

Explain in brief how does db2 determine what lock-size to use?

674


What are iseries servers?

644


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

705


Mention the various locks that are available in db2.

697


What is rct?

846






what is the responsibility of the construction superintendent

1745


Why do we need reorg in db2?

642


What is nvl in db2?

727


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?

2019


What is db2 instance?

686


Is it possible using max on a char column?

703


How to create db2 table in mainframe?

736


what is the role of the cursor in db2?

720


What is the difference between db2 and oracle?

761


What is a bind card?

770