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: 204
I have a grouped query, and would like to filter it based on count(*)
Can I do this without a subquery?
This is what I have currently:
select *
from (select ID,
count(*) cnt
from name
group by ID)
where cnt > 1;
© Stack Overflow or respective owner