Home > mailing lists

Re: DISTINCT and COUNT help - Mailing list pgsql-novice

From	Chris
Subject	Re: DISTINCT and COUNT help
Date	June 28, 2002 04:23:11
Msg-id	5.1.0.14.0.20020628151949.027f1d70@cooee.cybersydney.com.au Whole thread Raw
In response to	DISTINCT and COUNT help (Julie Keywell <julie@iparenting.com>)
List	pgsql-novice

Tree view

Hi Julie,

>I would like to count the number of distinct values in a column.  Is
>there any way to combine DISTINCT and COUNT and if so, what is the
>syntax?

Sure is.

SELECT DISTINCT column, COUNT(column) FROM table GROUP BY column;

HTH,

-----------------
      Chris Smith
http://www.squiz.net/

pgsql-novice by date:

From: Julie Keywell
Date: 28 June 2002, 04:11:16
Subject: DISTINCT and COUNT help

From: Manfred Koizar
Date: 28 June 2002, 08:25:57
Subject: Re: DISTINCT and COUNT help

Re: DISTINCT and COUNT help - Mailing list pgsql-novice

Previous

Next