XPost: comp.databases.oracle.misc   
   From: galenboyer@hotpop.com   
      
   On 11 Feb 2004, nbsj67@yahoo.com wrote:   
   > I need to find customer's names that repeat / occur more than   
   > once in the same table. I have treid many options and I have   
   > tried comparing the column to itself but Oracle gives me an   
   > error.   
      
   select cust_nm, count(*)   
   from table   
   group cust_nm   
   having count(*) > 1;   
      
   --   
   Galen Boyer   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)