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
- 16058 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
Outputs of explain are with matchcols = 0. What does this signify?
What are host variables in db2?
What is the use of predicate?
Discuss about db2 bind?
What is the difference between cursor and select statement?
What is the difference between using bind () and rebind () methods of naming class?
How to run db2 command in windows?
What is the max length of sqlca?
can we view the access paths created by dbrm ? how ? thx
What is runstats db2?
What is temporal table in db2?
What is isolation level in db2?
When do you specify the isolation level?
What is plan in cobol db2?
What is a plan and package in db2?
