Mastering Oracle's SELECT DISTINCT

HAVING

UNIQUE

DISTINCT (correct)

GROUP BY

DISTINCT can only be used in the SELECT statement, while UNIQUE can be used in any SQL statement

DISTINCT is not SQL standard, while UNIQUE is

There is no difference, they are synonyms (correct)

DISTINCT is used for filtering duplicate rows, while UNIQUE is used for defining unique constraints on columns

ORDER BY

HAVING

GROUP BY (correct)

WHERE

<p>It considers NULL values as duplicates of each other</p> Signup and view all the answers

<p>Specify the column list in the SELECT clause</p> Signup and view all the answers