具有多个between的SQL查询

Question

选择符合下列条件之一的国家:——人口1000万至2000万。——人口从4400万到5500万。

Please use the keywords BETWEEN.

这是一个问题。我写了查询，但没有得到输出。如果你有我在这里做的错误，请指导

这是我的查询:

select Id,Name,Capital,CurrencyCode,Population,EuropeUnionMember 
from Country 
where (population between 100000000 and 200000000) 
or (population between 440000000 and 550000000);

Answer 1

可以使用UNION命令实现。我在下面为您设置了一个简单的演示。根据你的需要量身定做。

CREATE table MY_TABLE (country, population) AS 
SELECT 'France',150000000
FROM dual UNION ALL
SELECT 'Spain',300000000
FROM dual UNION ALL
SELECT 'England',444000000
FROM dual;
select country, population from my_table where population between 100000000 and 200000000
UNION
select country, population from my_table where population between 440000000 and 550000000;

COUNTRY    POPULATION
England    444000000
France    150000000