Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete perticular row from table
for ex. how you will delete 3rd row from table
please answer
THANKS IN ADVANCE
- 10 Answers
- 15045 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / dalwinder singh
delete from (SELECT * FROM (SELECT col1,rownumber() over()
as rn from table where col =value) as tr where rn = 3)
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is an instance database?
What is the use of dclgen in db2?
What does db2 mean?
What is a dbrm in db2?
What is the difference between cursor stability and repeatable read isolation levels?
How can record locking be achieved in those DB2 versions which do not support it?
What do you mean by between and in? Is between inclusive of specified range values?
Which component is responsible for db2 startup and shutdown?
define clustering index.
Explain the function done by data manager?
Is db2 relational database?
How is a typical db2 batch pgm executed?
Define sqlca.
What is cobol db2?
