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

Answer Posted / ankit

hi

try with key word 'rownum' and 'rowcount'
ex: delete from table where rowcount=3;

correct me if i am wrong

Is This Answer Correct ?    3 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the full forms of spufi and dclgen and why are they used?

734


Is ibm db2 free?

664


If I have a view which is a join of two or more tables, can this view be updateable?

796


What is database manager in db2?

636


Explain the contents that are a part of dclgen.

743






What is the default page size of buffer pools?

739


How do you eliminate duplicate values in db2?

795


What do you mean by cursor?

684


Define db2.

756


What is a buffer in memory?

684


What language is db2 written in?

676


Is it possible to create an Instance in DB2 using DB2 Control Center ?

713


What is bind and rebind in db2?

738


How can we read records for specific member in CL? AND rpg?

323


What is the physical storage length of time data type?

767