how to delete perticular row from table
for ex. how you will delete 3rd row from table
please answer
THANKS IN ADVANCE
Answer Posted / prashant shettar
delete from (select rownumber() over() as rowid from tab1)
where rowid =3
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What r the comman abends in db2, jcl and cobol???????
What is concurrency?
Which components manage deadlocks in db2?
What is the physical storage length of the data types date, time, and timestamp?
What is reorg?
What is db2 look?
How do I delete a table in database?
How can record locking be achieved in those DB2 versions which do not support it?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is db2 optimizer?
What is difference between rollback and commit?
What is null indicator in cobol db2?
What is bind and rebind in db2?
What is the role of the data page in the db2 database?
What are the full forms of spufi and dclgen and why are they used?