Filter on count(*) in oracle

Posted by chris on Stack Overflow See other posts from Stack Overflow or by chris
Published on 2010-05-25T17:32:34Z Indexed on 2010/05/25 17:41 UTC
Read the original article Hit count: 200

select * 
  from (select ID,
               count(*) cnt
          from name
      group by ID)
 where cnt > 1;

© Stack Overflow or respective owner