From: Chris
Date: March 12 1999 2:19pm
Subject: Re: How to cope without COUNT(DISTINCT <field_name>)
List-Archive: http://lists.mysql.com/mysql/93
Message-Id: <Pine.LNX.3.96.990312091848.926D-100000@hiro.studentadvantage.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII


I believe the following will work:

SELECT count(*) FROM <tablename> GROUP BY <field_name>;

--Chris

On Fri, 12 Mar 1999, Holger Rauch wrote:

> Hi!
> 
> How can I do without COUNT(DISTINCT <field_name>)?
> (I was looking in the manual, but I couldn't find a solution there.
> In case I overlooked something, I apologize).
> 
> Any help will be greatly appreciated! Thanks in advance!
> 
> Greetings,
> 
> 	Holger
> 
> 
> 
> ---------------------------------------------------------------------
> To request this thread, e-mail mysql-thread64@stripped
> 
> To unsubscribe, e-mail the address in the List-Unsubscribe header.
> For additional commands, e-mail: mysql-help@stripped
>