Re: duplicates

From: Patrik Kudo <kudo(at)partitur(dot)se>
To: Allan Kelly <allan(dot)kelly(at)buildstore(dot)co(dot)uk>
Cc: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: duplicates
Date: 2000-04-07 11:33:25
Message-ID: 38EDC785.EA43733@partitur.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Regards,
Patrik Kudo

In response to

  • duplicates at 2000-04-07 10:34:01 from Allan Kelly

Browse pgsql-sql by date

  From Date Subject
Next Message Leonid P. Klemjatsionok 2000-04-07 12:04:18 Re[2]: update only if single row
Previous Message Patrik Kudo 2000-04-07 11:27:38 Re: duplicates