5.16. SQL Select Distinct

• Unique values

5.16.1. Distinct

SELECT DISTINCT agency
FROM astronauts;

5.16.2. Alias

SELECT DISTINCT agency AS ag
FROM astronauts;

5.16.3. With Query

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