Question: what is the difference between select distinct and group by?
Answer: Distinct is used to find unique/distinct records where as a group by is used to group a selected set of rows into summary rows by one or more columns or an expression. The functional difference is thus obvious. ... The group by gives the same result as of distinct when no aggregate function is present.