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

Answer Posted / shiva

delete from table where rowcount=3;

Is This Answer Correct ?    1 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we retrieve the total number of records in RPG & CLLE?

276


Define db2.

756


How would you find out the total number of rows in a db2 table?

667


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

1898


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

671






Is db2 a programming language?

693


How can deadlocks be resolved?

626


What is the picture clause of null indicator variable?

772


What's The Percentage Free Space ?

866


What is db2 catalog database?

659


How to find the maximum value in a column in the db2 database?

687


How does a cursor work?

634


What is the result of open cursor statement?

716


What is the difference between oracle and db2?

675


How many databases can be created inside an instance in db2 ?

701