Multiple choice technology databases

Which SELECT statement should you use if you want to display unique combinations of the POSITION and MANAGER values from the EMPLOYEE table?

  1. SELECT DISTINCT position, manager

  2. SELECT position, manager DISTINCT

  3. SELECT position, manager

  4. SELECT position, DISTINCT manager
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The DISTINCT keyword must immediately follow the SELECT keyword to filter duplicate rows. Placing DISTINCT elsewhere in the query is syntactically invalid, which rules out all other distractors.

Keep practicing — related questions