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 the prerogatives?
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
What is the information associated with sysibm.syslinks table?
What does db2 blu stand for?
What is bind plan?
What are the 2 sqlcodes that are returned?
Before you give the explain statement, what are the prerogatives?
What is reorg?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is a page in db2?
What is the maximum number of columns in a db2 table?
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?
Can there be more than one cursor open for any program?
How do I connect my db2 database to ibm?
Explain about open switch business continuity software?