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
What is check constraint in db2?
What is db2 stogroup?
Which command is used to connect to a database in DB2 ? Give the Syntax.
Is db2 free?
define clustering index.
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is a collection in db2?
What is the purpose of rollback and commit?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What parameters are used to control the free space in DB2?
How can we retrieve the total number of records in RPG & CLLE?
Explain various types of locks in db2?
What is the role of union all and union
What is a db2 tablespace?
My sql statement select avg(salary) from emp yields inaccurate results. Why?