You can use:
SELECT <Column_Name>, count(<Column_Name>) FROM <Table_Name> GROUP BY
<Column_Name>
> -----Original Message-----
> From: Franz, Fa. PostDirekt MA [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 16, 2001 3:02 AM
> To: [EMAIL PROTECTED]
> Subject: COUNT(DISTINCT <Column_Name>)
>
>
>
> Hi Everybody ,
>
> I am using MySql 3.22.32 on LINUX.
> My problem is , that 'SELECT COUNT(DISTINCT <Column_Name>) FROM
> <Table_Name>
> doesn't work
> like described in the HTML-manual (7.4.13) .
> It even doesn't work at all.
> Is tthat a bug , am I stupid , or is there any workaround.
>
> Greetings
> Klaus
>
> Besuchen Sie uns auch im Internet: http://www.postdirekt.de
>
> Diese Mail ist von:
> Deutsche Post Direkt GmbH
> Beleglese Center Mannheim
>
> Klaus Franz
> Manager Abgleichsysteme
>
> Willy-Brandt-Platz 13 Tel. 06 21.129 56 436
> 68161 Mannheim
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
