Select DISTINCT to include the DISTINCT keyword in the SELECT clause. This removes all but one row in each set of duplicate rows in the result table.

If you do not select DISTINCT, the DISTINCT keyword will not be included in the SELECT clause. This means that the result table will include all of the rows.