Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id CBDC1475996 for ; Fri, 19 Apr 2002 05:24:40 -0400 (EDT) Received: (qmail 31853 invoked by uid 0); 19 Apr 2002 09:24:38 -0000 Received: from pd9e6c8b2.dip.t-dialin.net (HELO wxp) (217.230.200.178) by mail.gmx.net (mp009-rz3) with SMTP; 19 Apr 2002 09:24:38 -0000 Message-ID: <006501c1e784$7f685d90$a57ba8c0@wxp> From: "Thorsten Wenzlaff" To: "pgsql" Subject: count different values in column? Date: Fri, 19 Apr 2002 11:27:59 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200204/247 X-Sequence-Number: 7511 Hello, today I have a new question :) I've a resulttable is generated by a couple of subselects and joins which contains only one column. Now I want to count the different values in the column. Resulttable : a ------ 10 12 12 12 14 14 15 I need the value which is repeated most in the resulttable (in this example 12 ) ! Any suggestions ? Thx berger