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
- 15445 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
define clustering index.
Can you use max on a char column?
What is the maximum size of a char data type in db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
List out the buffer pools in db2
What is table space in db2?
Define predicate?
What is the function of logging in the db2 database?
How do you find the maximum value in a column in db2?
What is a system catalog table in db2?
Give a brief description of db2 isolation levels?
What is db2 stogroup?
List out the data types available.
What is multi row fetch in db2?
What is database reorganization?
