Received: from eba-haus.de (pec-28.au1.f.uunet.de [149.228.241.28]) by hub.org (8.9.3/8.9.3) with SMTP id JAA37673 for ; Fri, 7 Apr 2000 09:01:21 -0400 (EDT) (envelope-from DieringG@eba-haus.de) Received: from kopo001 by eba-haus.de;Fri, 07 Apr 2000 12:54:13 GMT with Novell_GroupWise; Fri, 07 Apr 2000 14:54:14 +0200 Message-Id: X-Mailer: Novell GroupWise 5.5 Date: Fri, 07 Apr 2000 14:54:02 +0200 From: "Gerhard Dieringer" To: , Subject: Antw: duplicates Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id JAB37764 X-Archive-Number: 200004/70 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