|List:||General Discussion||« Previous MessageNext Message »|
|From:||Chris||Date:||March 11 1999 11:13pm|
|Subject:||Re: select count distinct|
|View as plain text|
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?