Is it possible to GROUP BY multiple columns using MySQL?

Question

In MySQL, Is it possible to GROUP BY more than one column using the SELECT query? 

For example:

GROUP BY fV.tier_id AND 'f.form_template_id'

Answer 1

Yes. In MySQL, we can group by multiple columns. 

Check out the below example,

SELECT * FROM table
GROUP BY col1, col2

The result will be initially grouped by col1, and then by col2. Also In MySQL, the column preference goes from left to the right.

Start your SQL career with the perfect SQL Training Course now!