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 / 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
Name the various locking levels available?
What is a storage group (stogroup)?
What is difference between rollback and commit?
What is runstats utility in db2?
What are the various isolation levels possible?
What is reorg and runstats in db2?
What is cloudant database?
What do you mean by cursor?
what is the sqlcode -501
What is page size in db2?
What is rebind in db2?
What type of database is db2?
List out the data types available.
Explain package in db2 and its advantages?
What is the clustering index in the db2 database?