Interested to Buy Any Domain ? << Click Here >> for more details...
how to get duplicate records from tables?write qurey for this?
- 4 Answers
- 9914 Views
- ANZ, I also Faced
- E-Mail Answers
Answer Posted / mahesh babu
select column_name,count(*) from table_name group by
column_name having count>1.
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Is ibm db2 free?
Highlight all the advantages that are attached to a package.
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Can you use max on a char column?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
Are view updateable?
Which isolation level provides highest data integrity?
What is db2 plan table?
What is the usage of open cursor command?
Define data page.
What are the uses of db2 optimizer?
What is db2 optimizer?
What is dclgen (declaration generator)?
What are the prerogatives?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
