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 comment

Design a site like this with WordPress.com
Get started