In my table having 100 Rec. How can I delete the 7th row??
(we don't know what is data inside the table)

Answer Posted / m sharib

delete from table1 where policy_no =(select policy_no from table1 limit 6,1);

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What kind of database is db2?

662


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

668


What is db2 bind?

709


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

700


Differentiate between cs and rr isolation levels? Where do you specify them?

671






What is the difference between spufi and qmf?

715


What are catalog tables in db2?

685


Explain packages.

755


What is db2?

819


What are iseries servers?

643


How to find the number of rows in db2 tables?

697


How do you eliminate duplicate values in db2?

795


How to check table size in db2 sap?

667


Explain the function done by data manager?

925


Define db2.

756