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.
