how to delete perticular row from table
for ex. how you will delete 3rd row from table
please answer
THANKS IN ADVANCE
Answer Posted / ankit
hi
try with key word 'rownum' and 'rowcount'
ex: delete from table where rowcount=3;
correct me if i am wrong
| Is This Answer Correct ? | 3 Yes | 11 No |
Post New Answer View All Answers
Is schema the same as database?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What do you mean by rollback?
What is ibm db2 used for?
How do I start db2 in windows?
Explain the function of data manager.
What is query_cache_limit?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
what is utility for parm lib
What is catalog database in db2?
What is runstats utility in db2?
What is ibm db2 client?
What is the role of union all and union
What is bind in db2?
Define data page.