Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 49196475DAC for ; Fri, 19 Apr 2002 05:27:25 -0400 (EDT) Received: (qmail 5290 invoked by uid 0); 19 Apr 2002 09:27:26 -0000 Received: from pd9e6c8b2.dip.t-dialin.net (HELO wxp) (217.230.200.178) by mail.gmx.net (mp007-rz3) with SMTP; 19 Apr 2002 09:27:26 -0000 Message-ID: <007901c1e784$e3c21010$a57ba8c0@wxp> From: "Albrecht Berger" To: "pgsql" Subject: count different values in column Date: Fri, 19 Apr 2002 11:30:47 +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/238 X-Sequence-Number: 7502 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