SQL – DISTINCT and GROUP BY Difference

Distinct and Group By executed the same result as well as query plan of execution.
Group BY clause is used whenever aggregate functions are used.
Distinct use to remove the duplicates and it can’t be use in aggregate functions.

examples for DISTINCT
SELECT DISTINCT col1
FROM table1

examples for GROUP BY
SELECT col1
FROM table1
GROUP BY col1

both query will return the same output.

Leave a Reply

Create your own website, free on WordPress.com.Create your own website.
Start free