how to delete perticular row from table
for ex. how you will delete 3rd row from table
please answer
THANKS IN ADVANCE

Answer Posted / krishna

Delete from TAb1
Where Rowcount(*)=3

i hope this is Correct

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create backup table in db2?

741


Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2413


What is reorg?

694


Is schema the same as database?

718


What do you mean by storage group (stogroup)?

682






What is a db2 package?

681


What is ibm db2 used for?

697


Explain the contents that are a part of dclgen.

743


Mention some fields that are a part of sqlca.

680


What is difference between alias and synonym in db2?

726


What is the role of data manager in the db2 database?

727


What is the use of predicate?

675


What does sqlcabc has?

705


What is the maximum length of sqlca?

980


What is the difference between dbm cfg and db cfg file in db2 ?

1104