9.12. SQL Select Distinct

9.12.1. Rationale

  • Unique values

9.12.2. Distinct

SELECT DISTINCT agency
FROM astronauts;

9.12.3. Alias

SELECT DISTINCT agency AS ag
FROM astronauts;

9.12.4. With Query

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