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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create your website at WordPress.com
Get started
%d bloggers like this: