riteshrajsingh

 Profile Answers by riteshrajsingh 

• Jan 18th, 2007

 

There are many ways to find out the count of duplicate entry like

if table is

field_name varchar2

a

b

then select field_name,count(*) from table_name group by field_name having count(*)>1

will give the duplicate entry count

Regards

Ritesh Singh

09322070038

mala321

 Profile Answers by mala321 

• Dec 24th, 2007

 

Hello,

select duplicate_column,count(duplicate_column) from table1 
       group by  duplicate column
      having count(duplicate_column) >1;

sachin_dac

 Profile Answers by sachin_dac 

• May 22nd, 2008

 

You can use these two methods to find out the Duplicate Entries. There are some more ways to do the same, But I am not able to recollect those at this time. Anyways these two will do the work for you.
        
        Select ename
        From emp
        Group by ename having count(ename) > 1 ;

        Select a.ename, b.empno
        from EMP a, EMP b
        where a.ename=b.ename
        and a.empno <> b.empno;

Showstopper

 Profile Answers by Showstopper 

• Jun 21st, 2010

 

We can count the duplicate entry in particular table by using the following query


select count(*)
from a b
where exists (select rowid
                       from a
                       where a.no1=b.no1
                       and a.rowid > b.rowid);

Waseem Mehmood

 Profile Answers by Waseem Mehmood 

• Jun 2nd, 2011

 

Select ename, count(ename) Count 
From emp 
Group by ename 

Having count(ename) > 1 ;