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