Re: select count distinct

[Chris]

This should work:

SELECT count(*), id FROM sometable GROUP BY id;

--Chris

> 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?