Multiple choice technology programming languages

How you will avoid duplicating records in a query?

  1. DISTINCT

  2. UNIQUE

  3. DISTINCT and UNIQUE

  4. None Of The Above

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The DISTINCT keyword is used in a SELECT statement to remove duplicate rows from the result set, ensuring each row is unique. While UNIQUE is a constraint used during table creation to prevent duplicate entries in a column, it is not a valid SQL command for filtering query results.