开发中自己出现的小坑,关于Oracle中group By
一开始 使用MySQL 开发时的查询语句
SELECT
SR."ID",
iu.NAME AS name,
sr.ROOM_CAPACITY AS roomCapacity,
sr.ROOM_AREA AS roomArea,
sr.REMARK,
COUNT(sp.POINT_ID) AS powerPointCount,
COUNT(rm.ID) AS roomMonitorCount
原创
2020-09-25 09:51:42 ·
245 阅读 ·
0 评论