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

What os does db2 run on?

955

Give the name of some fields form sqlca.

1057

What is the difference between oracle and db2?

1074

Is ibm db2 open source?

1052

define clustering index.

1008

What is collection in db2 bind?

991

Explain about cursor stability?

1022

What is the usage of open cursor command?

1082

What is db2 and what is the use of db2 optimizer?

1031

What does sqlcabc has?

1030

How and when does the db2 enforces the unique key?

1068

What is the default page size of buffer pools?

1108

What is the role of schema in the db2 database?

1246

What is null indicator in db2?

1091

What is db2? Explain.

1014