In my table having 100 Rec. How can I delete the 7th row??
(we don't know what is data inside the table)
- 9 Answers
- 13481 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / harsha
Use DELETE FROM TabName
The above command will delete all rows of the table with
out deleting the table.
Now if we want to delete 7th row and we don't know the
actual data in that row, then in that case we need to
create a new temporary result table, that contains only one
desired record which you want to delete.
Here are the steps.
1 Select only 7 row data.
2 Sort it in descending order(ORDER BY calue)
3 Select only first row
4 Now you have a result table with only 1 and desired record
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is sqlca’s maximum length?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
How to check table size in db2 sap?
List down the data types in the db2 database.
What is db2 catalog database?
What are catalog tables in db2?
What is the difference between spufi and qmf?
What is reorg and runstats in db2?
What are bind parameters in db2?
How to view db2 table structure?
What is the use of commit in db2?
what are bind concepts in db2 cobol?
Mention the location where the output received from explain statement is stored.
How many databases can be created inside an instance in db2 ?
How do I import a csv file into db2?
