Interested to Buy Any Domain ? << Click Here >> for more details...
how to get duplicate records from tables?write qurey for this?
- 4 Answers
- 9958 Views
- ANZ, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anshuman
Select column_name1,column_name2
from table_T
group by column_name1 having count(*)>1
it will give all the duplicates value of column_name1
| Is This Answer Correct ? | 28 Yes | 7 No |
Answer / mahesh babu
select column_name,count(*) from table_name group by
column_name having count>1.
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / naresh k
select * from table_name;
The above qurey get duplicate record also because the
database store records like multi-set..
if we want get distinct records then use following query.
select distinct(attribute_name) from table name
| Is This Answer Correct ? | 0 Yes | 15 No |
Answer / pandu
To get the duplicate records in a table use the query
Select distinct(deptno) from emp;
reply any one to me am i correct.
| Is This Answer Correct ? | 2 Yes | 26 No |
Explain about mirror activator disk mirroring?
Where besides the DB2 catalog is database object information stored by DB2?
What is the difference between oracle and db2?
What is the use of COMMAREA ?Minimum how much data we can pass from it?
What is a db2 collection?
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
What is the physical storage length of timestamp data type?
What are the prerogatives?
Can there be more than one cursor open for any program?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
what is REORG? what is the use?
What are host variables in db2?
COBOL 
