count different values in column? - Mailing list pgsql-sql

From Thorsten Wenzlaff
Subject count different values in column?
Date
Msg-id 006501c1e784$7f685d90$a57ba8c0@wxp
Whole thread Raw
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: SQL Query Optimization
Next
From: Stéphane DEWITTE
Date:
Subject: How to log outputs from pl/pgsql into a file ?