how to delete perticular row from table
for ex. how you will delete 3rd row from table
please answer
THANKS IN ADVANCE
Answer Posted / anjireddy vintha
delete from tablename where rownum=3
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is sqlca?
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?
What is a storage group (stogroup)?
What are bind parameters in db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
Mention data types used in db2 ?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
How many databases can be created inside an instance in db2 ?
What is the use of with ur in db2?
What is a bind in db2?
Why select is not preferred in embedded sql programs?
How many types of page locks can be held in db2?
What's The Error Code For Unique Index Voilation?
What happens in bind step in a db2 program?
List out the data types available.