mysql group by 、order by

1、group by

select 类别, sum(数量) as 数量之和 from A group by 类别

select 类别, sum(数量) AS 数量之和 from A group by 类别 order by sum(数量) desc
posted @ 2021-09-13 12:49  keep2021  阅读(40)  评论(0)  编辑  收藏  举报