Received: from sysadmin.chi.ubsw.com (sysadmin.chi.ubswarburg.com [146.180.1.66]) by postgresql.org (Postfix) with ESMTP id DEAD047510B for ; Fri, 19 Apr 2002 05:40:39 -0400 (EDT) Received: from devin by sysadmin.chi.ubsw.com with local (Exim 3.12 #2) id 16yUse-0001Y4-00; Fri, 19 Apr 2002 04:40:36 -0500 Date: Fri, 19 Apr 2002 04:40:35 -0500 (CDT) From: Tod McQuillin X-X-Sender: devin@sysadmin To: Albrecht Berger Cc: pgsql Subject: Re: count different values in column In-Reply-To: <007901c1e784$e3c21010$a57ba8c0@wxp> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200204/239 X-Sequence-Number: 7503 On Fri, 19 Apr 2002, Albrecht Berger wrote: > 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 ) ! SELECT a, count(a) FROM resulttable GROUP BY a ORDER BY 2 DESC -- Tod McQuillin