Re: Group expansion as part of the result

2012-03-27 Thread Paul Halliday
On Tue, Mar 27, 2012 at 3:43 PM, Dan Nelson wrote: > In the last episode (Mar 27), Paul Halliday said: >> Say I have: >> >> SELECT COUNT(name), name, COUNT(DISTINCT(status)) FROM table GROUP BY name >> >> and it returns: >> >> 20 paul 5 >> 19 john 2 >> 75 mark 3 >> >> is there a way to return what

Re: Group expansion as part of the result

2012-03-27 Thread Dan Nelson
In the last episode (Mar 27), Paul Halliday said: > Say I have: > > SELECT COUNT(name), name, COUNT(DISTINCT(status)) FROM table GROUP BY name > > and it returns: > > 20 paul 5 > 19 john 2 > 75 mark 3 > > is there a way to return what comprises DISTINCT(status) as part of the > result? > > s