Received: from bastuba.partitur.se (bastuba.partitur.se [193.219.246.194]) by hub.org (8.9.3/8.9.3) with ESMTP id HAA27655 for ; Fri, 7 Apr 2000 07:33:30 -0400 (EDT) (envelope-from kudo@partitur.se) Received: from partitur.se (tb303.partitur.se [193.219.246.230]) by bastuba.partitur.se (8.8.8/8.8.8) with ESMTP id NAA25346; Fri, 7 Apr 2000 13:33:25 +0200 (CEST) (envelope-from kudo@partitur.se) Message-ID: <38EDC785.EA43733@partitur.se> Date: Fri, 07 Apr 2000 13:33:25 +0200 From: Patrik Kudo X-Mailer: Mozilla 4.72 [en] (X11; I; FreeBSD 4.0-STABLE i386) X-Accept-Language: en MIME-Version: 1.0 To: Allan Kelly CC: "pgsql-sql@postgresql.org" Subject: Re: duplicates References: <38EDB999.EA91E2DB@buildstore.co.uk> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200004/66 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