Is it possible to GROUP BY multiple columns using MySQL

Question

Is it possible to GROUP BY more than one column in a MySQL SELECT query  For example     GROUP BY fV tier id AND  f form template id

User · Answer

To use a simple example  I had a counter that needed to summarise unique IP addresses per visited page on a site  Which is basically grouping by pagename and then by IP  I solved it with a combination of DISTINCT and GROUP BY   SELECT pagename  COUNT DISTINCT ipaddress  AS visit count FROM log visitors GROUP BY pagename ORDER BY visit count DESC

User · Answer

GROUP BY col1  col2  col3

User · Answer

Yes  you can group by multiple columns  For example   SELECT   FROM table GROUP BY col1  col2   The results will first be grouped by col1  then by col2  In MySQL  column preference goes from left to right

User · Answer

group by fV tier id  f form template id

User · Answer

GROUP BY CONCAT col1       col2

User · Answer

Yes  but what does grouping by more two columns mean  Well  it s the same as grouping by each unique pair per row  The order you list the columns changes the way the rows are sorted   In your example  you would write   GROUP BY fV tier id  f form template id  Meanwhile  the code  GROUP BY f form template id  fV tier id  would give similar results  but sorted differently

User · Answer

If you prefer  I need to apply this  group by two columns at same time  I just saw this point   SELECT CONCAT  col1       col2  AS Group1     GROUP BY Group1

[mysql] Is it possible to GROUP BY multiple columns using MySQL?

Examples related to mysql

Examples related to sql

Examples related to group-by