i have a table like this :
Name ADDRESS
Toto 123 ...
Toto 456
ToTo 678
I would like to delete 2 last row...please tell me how to
delete its
Answer Posted / mithlesh
delete from table_name
where address = '456' and '678'.
| Is This Answer Correct ? | 10 Yes | 4 No |
Post New Answer View All Answers
How does db2 sample database connect?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
what is the sqlcode -501
What is check constraint. Explain with example.
How do you eliminate duplicate values in db2?
How to find the number of rows in a db2 table?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is db2 instance?
What is the reason behind not using select * in embedded sql programs?
How do I copy a table in db2?
Explain about mirror activator disk mirroring?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What are concurrency issues?
Define data page.
What is explain in db2?