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 is db2 restart?

2218

How do I copy a table in db2?

1059

What is the difference between drop table and delete table?

1290

When reorg is used?

1184

How do you select a row using indexes in db2?

1178

What is db2 instance?

1165

What is bind and rebind in db2?

1191

What are the various isolation levels possible?

1181

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3637

Is db2 a programming language?

1104

Define data page.

1134

What is the syntax for seeing the columns and data types of a table in the db2 database?

1239

How to execute stored procedures?

1178

What is the use of db2 optimizer?

1175

How can you do the explain of a dynamic sql statement?

1112