Is it possible to GROUP BY multiple columns using MySQL?

mysql sql group-by
Rhys Thought picture Rhys Thought · Dec 3, 2009 · Viewed 347.6k times · Source

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'

Answer

Joe Phillips picture Joe Phillips · Dec 3, 2009 
GROUP BY col1, col2, col3

Related questions

Retrieving the last record in each group - MySQL

There is a table messages that contains data as shown below: Id Name Other_Columns ------------------------- 1 A A_data_1 2 A A_data_2 3 A A_data_3 4 B B_data_1 5 B B_data_2 6 C C_data_1 If I run a query select * …

Read More
MySQL Query GROUP BY day / month / year

Is it possible to make a simple query to count how many records I have in a determined period of time like a year, month, or day, having a TIMESTAMP field, like: SELECT COUNT(id) FROM stats WHERE record_date.…

Read More
Error related to only_full_group_by when executing a query in MySql

I have upgraded my system and have installed MySql 5.7.9 with php for a web application I am working on. I have a query that is dynamically created, and when run in older versions of MySql it works fine. Since upgrading …

Read More