Interested to Buy Any Domain ? << Click Here >> for more details...
How will you delete duplicate records from a table?
- 7 Answers
- 25333 Views
- Google, I also Faced
- E-Mail Answers
Answer Posted / venkat
delete from emp where ecode IN ( select ecode from emp group by ecode having count(*) >1 )
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
Explain about dbrm.
Explain the contention situations caused by locks?
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 cobol picture clause of the db2 data types date, time, timestamp?
What does db2 mean?
What is drop table?
Why db2 is called db2?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
define clustering index.
Is it possible using max on a char column?
Why do chiropractors use drop table?
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 are db2 objects?
What is temporal table in db2?
How to retrieve rows from a db2 table in embedded sql?
