6.22. SQL Select Distinct

  • Unique values

6.22.1. Distinct

SELECT DISTINCT agency
FROM astronauts;

6.22.2. Alias

SELECT DISTINCT agency AS ag
FROM astronauts;

6.22.3. With Query

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