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
- 14563 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 the difference between spufi and qmf?
Which command is used to remove all rows from a table?
What does db2 plan contain?
What is query_cache_limit?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
Is db2 relational database?
What is copy pending status in db2?
What are the various data types available in db2?
What is the maximum number of columns in a db2 table?
Define sqlca.
List some fields from sqlca?
Explain about cursor stability?
What is the usage of open cursor command?
What is the difference between using bind () and rebind () methods of naming class?
What is consistency token in db2?
