Multiple choice

Which SELECT statement should be used if unique combinations of the POSITION and MANAGER values from the EMP table should be displayed?

  1. SELECT DISTINCT position, manager FROM emp;

  2. SELECT position, DISTINCT manager FROM emp;

  3. SELECT position, manager FROM emp;

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

Option A correctly uses SELECT DISTINCT to retrieve unique combinations of position and manager values. The DISTINCT keyword applies to the entire row combination, not just the column immediately following it. Option B incorrectly places DISTINCT after only one column name, option C returns all rows including duplicates, and option D has invalid syntax with DISTINCT placed incorrectly.

Keep practicing — related questions