Antw: duplicates - Mailing list pgsql-sql

From Gerhard Dieringer
Subject Antw: duplicates
Date
Msg-id s8edf696.073@kopo001
Whole thread Raw
List pgsql-sql
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





pgsql-sql by date:

Previous
From: Jan Varga
Date:
Subject: subquery returnig more than one field
Next
From: "Bryan White"
Date:
Subject: Re: duplicates