how to delete perticular row from table
for ex. how you will delete 3rd row from table
please answer
THANKS IN ADVANCE
Answer Posted / krishna
Delete from TAb1
Where Rowcount(*)=3
i hope this is Correct
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What are bind parameters in db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Explain about dbrm.
Differentiate between cs and rr isolation levels? Where do you specify them?
List some fields from sqlca?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is the function of logging in the db2 database?
Explain in detail about buffer manager and its functionalities?
Explain dclgen.
What is runstats db2?
Explain about open switch business continuity software?
What is cursor with hold option in db2?
Explain about rct in db2?