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 subscribers
group by user_name having count(*) > 1;
Gerhard