Re: select(count(distinct(status))

It should work fine as printed...but you'll need mysql 3.23.xx On Fri, 6 Apr 2001, Temeschinko, Michael wrote: > > hi, > > I need to make a select like above in the subject count distinct (I need the > count of the different values of a coloumn) > > Hope you guys won't let me die silly! > :-)

select(count(distinct(status))

hi, I need to make a select like above in the subject count distinct (I need the count of the different values of a coloumn) Hope you guys won't let me die silly! :-) greetings from germany Micha -- A train station is a station where a train stops But what the hell is a workstation?