From: ChinaConnect
Date: March 11 1999 11:23pm
Subject: select count distinct
List-Archive: http://lists.mysql.com/mysql/61
Message-Id: <Pine.LNX.4.04.9903111822180.11768-100000@petra.intl.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

Hi,
In mysql, it doesn't look like you can do this:
select count(distinct id) from sometable.

If this is true, how would I count the number of times distinct ids occur?

G