6.17. SQL Select Distinct

  • Unique values

6.17.1. Distinct

SELECT DISTINCT agency
FROM astronauts;

6.17.2. Alias

SELECT DISTINCT agency AS ag
FROM astronauts;

6.17.3. With Query

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