delete from table1 where policy_no =(select policy

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

Question Posted / m sharib

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

Please Help Members By Posting Answers For Below Questions

Give the name of some fields form sqlca.

1074

Why do chiropractors use drop table?

1101

What is consistency token in db2?

1141

What is a collection in db2?

1032

How do I add a column in db2?

1048

What is the use of runstats in db2?

1104

what are bind concepts in db2 cobol?

1090

What are types of indexes?

1069

What is db2 optimizer?

1231

What is a db2 cursor?

1053

What kind of database is db2?

1032

What is copy pending and check pending in db2?

1000

What is cursor with hold option in db2?

1069

What is netezza database?

1025

Mention the different locking levels that are available in db2.

1127