Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 15790 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 are bind concepts in db2 cobol?
Highlight all the advantages that are attached to a package.
What is the difference between drop table and delete table?
What is db2 purescale?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is bufferpool in db2?
What is dclgen in db2?
What is the syntax for creating a table in the db2 database?
What is db2 and what is the use of db2 optimizer?
What is explain plan in db2?
What is the difference between cursor stability and repeatable read isolation levels?
What is the use of with ur in db2?
What is coalesce in db2?
What is the function of logging in the db2 database?
Explain the function done by data manager?
