List:General Discussion« Previous MessageNext Message »
From:Paul Halliday Date:March 27 2012 5:23pm
Subject:Group expansion as part of the result
View as plain text  
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

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