“The go to solution for removing duplicate rows from your result
sets is to include the distinct keyword in your select statement.
It tells the query engine to remove duplicates to produce a result
set in which every row is unique. Did you know that the group by
clause can also be used to remove duplicates? If not, read on to
find out what the main differences are between them and which to
use to produce a desired result.
“The Distinct and Distinctrow Keywords
“The distinct keyword comes directly after the SELECT in the
query statement and replaces the optional all keyword, which is the
default. Distinctrow is an alias for distinct and produces the
exact same results:”