Thread: Antw: duplicates

Antw: duplicates

From
"Gerhard Dieringer"
Date:
Allan Kelly wrote:
...
> At the moment we use this cludge:
>
> select count(*), user_name from subscribers
>    group by user_name order by count;
>
>(I'm surprised I can't add 'where count > 1' but it seems conditionals on 
>aggregate fields are not allowed).


Try select count(*), user_name from subscribersgroup by user_name having count(*) > 1;

Gerhard