3.Review 复习 SELECT 查询

最新推荐文章于 2021-08-13 11:32:05 发布

April临末

最新推荐文章于 2021-08-13 11:32:05 发布

阅读量175

点赞数

分类专栏： SQl

本文链接：https://blog.csdn.net/cnuwsn/article/details/105005227

版权

4 篇文章 0 订阅

订阅专栏

在这里插入图片描述

select city , population from north_american_cities where country like ‘%canada%’; 或者 SELECT city, population FROM north_american_cities WHERE country = “Canada”;
select city, latitude from North_american_cities where country = “United States” order by latitude desc;
select city ,longitude from north_american_cities where longitude < -87.629798 order by longitude;
select city,population from North_american_cities
where country = “Mexico”
order by population desc
limit 2;
select city,population from North_american_cities
where country = “United States”
order by population desc
limit 2,2;

country like ‘%canada%’ ,注意此处为单括号

country = “Canada”，注意此处为双括号

以上内容来自我在下面网上学习所做的笔记

https://sqlbolt.com/lesson/select_queries_with_joins

http://xuesql.cn/lesson/select_queries_with_joins

关注