RE: SELECT...GROUP BY WITHIN GROUP BY

2006 20:56 To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: SELECT...GROUP BY WITHIN GROUP BY I'm not sure that this is exactly what you want, but I think you can use the WITH ROLLUP modifier: select district, town, street, surname, count(surname) from test5 group by district asc

SELECT...GROUP BY WITHIN GROUP BY

Hope I have the right group. I am working out how to get groups within groups. e.g. I have a table with 4 columns C1,C2,C3 C4 I am looking to select data so that I can get C1 group item C2 Group item C3 Group Item C4 detail End of C3 Group Item count/totals of

Re: SELECT...GROUP BY WITHIN GROUP BY

://dev.mysql.com/doc/refman/5.0/en/group-by-modifiers.html Donna Kerry Frater [EMAIL PROTECTED] 11/28/2006 02:31 PM Please respond to [EMAIL PROTECTED] To mysql@lists.mysql.com cc Subject SELECT...GROUP BY WITHIN GROUP BY Hope I have the right group. I am working out how to get groups

RE: SELECT...GROUP BY WITHIN GROUP BY

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 20:56 To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: SELECT...GROUP BY WITHIN GROUP BY I'm not sure that this is exactly what you want, but I think you can use the WITH ROLLUP modifier