If you specify DISTINCT in a SELECT statement, all duplicate rows are removed from the result set. One row is retained from each group of duplicates. If you specify the ALL keyword instead, all rows are retained. This is the default value.