6.16. SQL Select Distinct

  • Unique values

6.16.1. Distinct

SELECT DISTINCT agency
FROM astronauts;

6.16.2. Alias

SELECT DISTINCT agency AS ag
FROM astronauts;

6.16.3. With Query

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