Postgres Pro
Downloads
Home   >   mailing lists

Re: duplicates - Mailing list pgsql-sql

From Patrik Kudo
Subject Re: duplicates
Date
Msg-id 38EDC785.EA43733@partitur.se
Whole thread Raw
In response to duplicates  (Allan Kelly <allan.kelly@buildstore.co.uk>)
List pgsql-sql
Tree view 
Hi again.

Your query:

> select count(*), user_name from subscribers
>         group by user_name order by count;
> 

would work if you instead wrote:

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

Regards,
Patrik Kudo

pgsql-sql by date:

Previous
From: Patrik Kudo
Date:
Subject: Re: duplicates
Next
From: "Leonid P. Klemjatsionok"
Date:
Subject: Re[2]: update only if single row