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


Please Help Members By Posting Answers For Below Questions

What are the different types of base tables?

578


What's The Percentage Free Space ?

758


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3112


What is dbrm library?

571


What does a deadlock mean in DB2?

643






What is rebind in db2?

568


Explain the contents that are a part of dclgen.

651


I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

2748


What is a bind card?

677


what is diffrence b/w file-aid tool and file-aid utility???

4168


What is difference between isnull and coalesce?

610


What are the uses of db2 optimizer?

813


Explain package in db2 and its advantages?

589


What is the use of with ur in db2?

610


What is dclgen in db2?

668