group by 与order by 一起如何使用

Pluto652

已于 2022-03-31 17:35:55 修改

阅读量3w

点赞数 4

分类专栏：笔记文章标签： java sql 数据库

于 2022-03-31 17:32:34 首次发布

本文链接：https://blog.csdn.net/weixin_55823910/article/details/123878299

版权

笔记专栏收录该内容

22 篇文章 0 订阅

订阅专栏

ORDER BY 语句用于对结果集进行排序。

ORDER BY 语句

ORDER BY 语句用于根据指定的列对结果集进行排序。

ORDER BY 语句默认按照升序对记录进行排序。

实例 
以逆字母顺序显示公司名称，并以数字顺序显示顺序号：

SELECT Company, OrderNumber FROM Orders ORDER BY Company DESC, OrderNumber ASC

对数据进行分组排序时group by 与order by 一起使用是要遵守一定原则的

要求：

1.order by 的列，必须是出现在group by 子句里的列

2.order by 要放在 group by的后面

实例：
		SELECT
		DISTINCT
		e.LOCATION AS "sortNum",
		min(e.COMMUNITY_ID) AS "communityId",
		min(e."NAME") AS "equipmentName",
		min(e.ORDER_STATE) AS "orderState",
        min(e.ID) AS "id",
	    min(e.LOCATION_REMARK) as "locationRemark"
		FROM
		EQUIPMENT e
		LEFT JOIN  EQUIPMENT_TYPE_TREE t ON e.EQUIPMENT_TYPE_ID=t.id AND t.DEL_FLAG='0'
	    GROUP BY e.LOCATION
		ORDER BY e.LOCATION DESC