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';