【sqlzoo】— select in select

[8] List the name and continent of countries in the continents containing either Argentina or Australia. Order by name of the country.
答案:
select continent,name from world x where x.name=(select top 1 name from world y where y.continent=x.continent order by name)


版权声明:本文为weixin_41801130原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。