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

From Ludwig Lim
Subject Re: DISTINCT and COUNT help
Date
Msg-id 20020628105140.13482.qmail@web40011.mail.yahoo.com
Whole thread Raw
In response to DISTINCT and COUNT help  (Julie Keywell <julie@iparenting.com>)
List pgsql-novice
Julie:

--- Julie Keywell <julie@iparenting.com> wrote:
> Hi there!
>
> 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?

try SELECT COUNT(DISTINCT(<column name>))
    FROM .....


ludwig


__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com



pgsql-novice by date:

Previous
From: AarniRuuhimäki / Megative Tmi / KYMI.com
Date:
Subject: Parser function / command ?
Next
From: Tony Griffiths
Date:
Subject: Accessing geometric values from embedded SQL