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
- 14068 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 types of tables are there in the db2 database?
Explain correlated sub-queries.
List out the buffer pools in db2
Explain how can you do the explain of a dynamic sql statement?
What is the syntax for creating a table in the db2 database?
How do we specify index to include or not during bind process.
What is dclgen (declaration generator)?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is data manager?
What does db2 blu stand for?
What is a db2 package?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is host variable in db2 cobol?
How do I import a csv file into db2?
What is database reorganization?
