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
- 14635 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 to take backup of table in db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is a system catalog table in db2?
Define buffer pool.
How can deadlocks be resolved?
What is the role of union all and union
What is database manager in db2?
What language is db2 written in?
What is dpf in db2?
What is host variable?
What is cursor stability in db2?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is difference between isnull and coalesce?
Define db2.
What is runstats utility in db2?
