distinct postgresql

What Is The Difference Between Distinct And Group By? 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 group by gives the same result as of distinct when no aggregate