Leetcode 595. Big Countries

考察的是SQL中查询语句的写法.

一般格式:

SELECT ...

FROM ...

WHERE...

两种写法:

1.用OR

# Write your MySQL query statement below
SELECT name,population,area 
FROM world
WHERE area>3000000 OR population >25000000;

2.用UNION

# Write your MySQL query statement below
SELECT name,population,area 
FROM world
WHERE area>3000000
UNION
SELECT name,population,area 
FROM world
WHERE population > 25000000;

 

转载于:https://www.cnblogs.com/zywscq/p/10652736.html