dhl快递公司,重生之欧美纵横,延纳里斯
下面是我学习sql语句中的出错的和疑问,算是总结。
8. exclusive or (xor). show the countries that are big by area or big by population but not both. show name, population and area.
australia has a big area but a small population, it should be included.indonesia has a big population but a small area, it should be included.china has a big population and big area, it should be excluded.united kingdom has a small population and a small area, it should be excluded.
select name,population,area from world where ((area < 3000000 and population>250000000) or (area > 3000000 and population < 250000000))
有没有更简单的写法?
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
数据库SQL---数据库、基本表、视图、索引的定义、修改、删除
在 Azure CentOS VM 中配置 SQL Server 2019 AG - (上)
在 Azure CentOS VM 中配置 SQL Server 2019 AG - (下)
网友评论