解法一:正常解法
# Write your MySQL query statement below
select
name, population, area
from
World
where
area >= 3000000
or population >= 25000000
解法二:利用union加速
上述算法较为直接,但速度慢
select
area, name
from
World
where
area >= 3000000
union
select
name, population
from
World
where
population >= 25000000
这样写是不对的,会把有的列弄没,两个表得一致才行
select
area, name, population
from
World
where
area >= 3000000
union
select
name, population, area
from
World
where
population >= 25000000
这样就对了, 但经过实测,也没快多少。。。。
还是第一种方法实用
select
name, area, population
from
World
where
area >= 3000000
union
select
name, area, population
from
World
where
population >= 25000000