ORDER BY 排序 从小到大
SELECT district ,SUM(population)
FROM city
WHERE countrycode='CHN'
GROUP BY district
ORDER BY SUM(population) ;
--- 例子：查询中国所有的城市，并以人口数降序输出
SELECT *
FROM city
WHERE countrycode='CHN'
ORDER BY population DESC;人口数从大到小输出
ORDER BY 排序 从小到大
SELECT district ,SUM(population)
FROM city
WHERE countrycode='CHN'
GROUP BY district
ORDER BY SUM(population) ;
--- 例子：查询中国所有的城市，并以人口数降序输出
SELECT *
FROM city
WHERE countrycode='CHN'
ORDER BY population DESC;人口数从大到小输出
ORDER BY 排序 从小到大 SELECT district ,SUM(population) F...
排序order byasc 默认desc单列排序SELECT * FROM 表明 ORDER BY age (...
排序：Order by select * from company order by salary asc; ...
排序 关键字 order by 单字段排序格式select * from where 条件 order by 字段...
检索多个列（SELECT） 检索某列，并排序（ORDER BY） ORDER BY语句必须是SELECT语句的最后...
排序数据_ORDER BY SELECT prod_name from products ORDER BY pro...
1 语法：select * from table order by <排序字段1> <排序方式1>,<排序字段2>...
检索排序数据语句select aaa from bbb order by aaa 单列排序
排序 ORDER BY SELECT <*, column [alias], ...>FROM table [WH...
排序查询 order by select 字段名 from 表名 order by 字段1 [asc|desc],...
本文标题：select 配合order by 排序
本文链接：https://www.haomeiwen.com/subject/pxurlctx.html
网友评论