List:General Discussion« Previous MessageNext Message »
From:Paul Halliday Date:March 28 2012 12:58am
Subject:Re: Group expansion as part of the result
View as plain text  
On Tue, Mar 27, 2012 at 3:43 PM, Dan Nelson <dnelson@stripped> 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 comprises  DISTINCT(status) as part of the
> result?
>>
>> so:
>>
>> 20 paul 2,3,1,20,9
>> 19 john 20,9
>> 75 mark 1,20,9
>
> You want GROUP_CONCAT:
>

Heh, and exactly how I wanted it formatted.

Great! Thanks.

-- 
Paul Halliday
http://www.squertproject.org/
Thread
Group expansion as part of the resultPaul Halliday27 Mar
  • Re: Group expansion as part of the resultDan Nelson27 Mar
    • Re: Group expansion as part of the resultPaul Halliday28 Mar