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 / rajeev
In this scenario RRN will be useful.
DELETE FROM <FILENAME> F1 WHERE RRN(F1) = 7
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the use of dclgen in db2?
Which component is used to execute the sql statements?
What does db2 blu stand for?
What language is db2 written in?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
Describe major components of db2?
can we view the access paths created by dbrm ? how ? thx
What's The Percentage Free Space ?
How do you eliminate duplicate values in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is consistency token in db2?
What is temporal table in db2?
What is collection in db2 bind?
Discuss about db2 bind?
How to find the number of rows in db2 tables?