| 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 result | Paul Halliday | 27 Mar |
| • Re: Group expansion as part of the result | Dan Nelson | 27 Mar |
| • Re: Group expansion as part of the result | Paul Halliday | 28 Mar |
