You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
-- Use a SELECT DISTINCT statement to get the distinct (i.e. unique) values that occur in the locality column from the bird.antarctic_populations table.
SELECT DISTINCT
locality
FROM
bird.antarctic_populations (NOLOCK);
--Use a SELECT DISTINCT statement to get the distinct combinations of values for both the locality and species_id columns from the bird.antarctic_populations table