SELECT continent,name from ( SELECT continent, name, ROW_NUMBER() OVER (PARTITION BY continent ORDER BY name) AS row_num FROM world ) AS ranked WHERE row_num = 1;