我有一个名为国家/地区的表,其中有一列名为人口。我需要一张只包含最高和最低人口国家的表格。我试过:
select max(population) from country;
select min(population) from country;
但我无法弄清楚如何将这些查询合并为一个查询。
愿你安好!
select min(population), max(population) from country;
将得到一个包含两列的结果,第一列保存最小总体,第二列保存最大总体。
不过,这只会返回人口。如果您需要的是将返回两个国家/地区的查询,则嵌入式查询将执行以下操作:
select * from country where population=(select min(population) from country) or population=(select max(population) from country);
试试这个:
select country,min(population) from country
group by 1
Union
select country,max(population) from country
group by 1
order by 1;