how to delete perticular row from table
for ex. how you will delete 3rd row from table
please answer
THANKS IN ADVANCE
Answer Posted / siri
DELETE FROM TABLENAME WHERE <3ROW>=VALUE
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
How to run db2 command in windows?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is ibm db2 used for?
What is dbrm? What it contains?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
Explain package in db2 and its advantages?
How to take backup of table in db2?
What is with ur in db2?
What is an instance in db2?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Explain correlated sub-queries.
What is view db2?
What is a dbrm in db2?