Blog 04 – Week 7

This week we covered MySQL ‘Group by’ and it’s extension ‘Having’.
‘Group by’ groups the output of a select statement by combining rows that have a column with repeating data, which can then be filtered using the ‘Having’ statement.
SELECT data1, data2
FROM table
GROUP BY data1
HAVING data1 > 3