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
Why do we need reorg in db2?
What is buffer pool?
What is query_cache_limit?
How to find schema of a table in db2?
How do I change the column size in db2?
Which are the db2 tools to protect integrity of the database?
What is data manager?
What is reorg?
What is the purpose of using commit?
Define data page.
What is the role of data manager in the db2 database?
What is the difference between oracle and db2?
What is difference between isnull and coalesce?
How to find primary key of a table in db2?
Explain dclgen.