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 is role in db2?
What is a bind in db2?
What is db2 catalog database?
what is diffrence b/w file-aid tool and file-aid utility???
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is view db2?
Explain how can you do the explain of a dynamic sql statement?
What is declare cursor?
What is image copy in db2?
Define data page.
What is dbrm? What it contains? When it will be created?
What are host variables in db2?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is the physical storage length of time data type?
How to find the maximum value in a column in the db2 database?