how to delete perticular row from table
for ex. how you will delete 3rd row from table
please answer
THANKS IN ADVANCE
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
What is ibm db2 used for?
How to find the number of rows in db2 tables?
Are views updateable?
What is host variable in db2 cobol?
What is difference between isnull and coalesce?
What is db2 instance?
Name the lockable units in DB2?
List down the data types in the db2 database.
What is cursor stability in db2?
When reorg is used?
What is db2 look?
i want to maintain uniqueness on pdf without make lf??????????
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What does db2 blu stand for?
What is bind in db2?