GROUP BY

Question

What is the diference between GROUP BY and DISTINCT?

Answer 1

with GROUP BY you can use aggregate functions like SUM or AVG.

Answer 2

example select distinct shows you unique values while group by statment is used in conjuction with the aggregate functions to group the results by one or more columns