Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete perticular row from table
for ex. how you will delete 3rd row from table
please answer
THANKS IN ADVANCE
- 10 Answers
- 14938 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
List down the types of triggers in the db2 database?
When reorg is used?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What are the various data types available in db2?
What is bind and rebind in db2?
How do I import data from excel to db2?
Can you tell me how can you find out the # of rows updated after an update statement?
What is drop table?
What are concurrency issues?
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 the difference between oracle and db2?
What does db2 stand for?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is the clustering index in the db2 database?
How to create db2 table in mainframe?
