8.12. SQL Select Distinct

8.12.1. Rationale

  • Unique values

8.12.2. Distinct

SELECT DISTINCT agency
FROM astronauts;

8.12.3. Alias

SELECT DISTINCT agency AS ag
FROM astronauts;

8.12.4. With Query

SELECT DISTINCT agency
FROM astronauts
WHERE location = 'Europe';