how to delete perticular row from table
for ex. how you will delete 3rd row from table
please answer
THANKS IN ADVANCE
- 10 Answers
- 12001 Views
- IBM, I also Faced
- E-Mail Answers
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
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What does db2 mean?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is the difference between spufi and qmf?
What is cursor with hold option in db2?
What is role in db2?
How to find primary key of a table in db2?
Explain the function done by data manager?
How to execute stored procedures?
How to test SQL -911 error while developing COB-DB2 program
Explain what are the various isolation levels possible?
What is a system catalog table in db2?
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 ?
What is meant by dclgen?
What is the maximum size of a char data type in db2?
