GROUP BY | SoloLearn: Learn to code for FREE!

0

GROUP BY

What is the diference between GROUP BY and DISTINCT?

sql

2/16/2017 6:38:56 PM

Ondra

2 Answers

New Answer

+3

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

0

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