获取一个group by里面的总和或者聚合函数 思路杂乱 不要看

SELECT
– staff_sum.sum,
TS_STAFF_INFO.STAFF_NAME,
staff_sum.sum,
TF_COMPANY_INFO.COMPANY_NAME
FROM
(
SELECT
SUM( NUM ) sum,
STAFF_ID
FROM
TF_INTEGRAL_DETAILED
WHERE
TO_CHAR ( CREATE_TIME, ‘YYYY-MM-DD’ ) = ‘2020-06-30’
GROUP BY
STAFF_ID
ORDER BY
SUM( NUM ) DESC
) staff_sum
LEFT JOIN TS_STAFF_INFO ON staff_sum.STAFF_ID = TS_STAFF_INFO.STAFF_ID
left join TF_COMPANY_INFO on TF_COMPANY_INFO.ID=TS_STAFF_INFO.COMPANY_ID

下面稍微讲解下