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;

 

posted @ 2019-04-04 06:50  周洋  阅读(128)  评论(0编辑  收藏  举报