SELECT
[One_project],
[Two_project],
[Three_project],
[XM_ID],
[TR_Year],
SUM (S_TR) AS S_TRCount,
SUM (ZY_TR) AS ZY_TRCount,
SUM (HY_TR) AS HY_TRCount,
SUM (QT_TR) AS QT_TRCount,
GROUPING(One_project),
GROUPING(Two_project),
GROUPING(Three_project),
GROUPING(XM_ID),
GROUPING(TR_Year)
FROM
[input]
GROUP BY
One_project,
Two_project,
Three_project,
XM_ID,
TR_Year WITH rollup
哪位前辈可否给点注释。。。。。
...全文
853打赏收藏
sql语句的疑问
SELECT [One_project], [Two_project], [Three_project], [XM_ID], [TR_Year], SUM (S_TR) AS S_TRCount, SUM (ZY_TR) AS ZY_TRCount, SUM (HY_TR) AS HY_TRCount, SUM (QT_TR) AS QT_TRCount, GROUPING(One_project), GROUPING(Two_project), GROUPING(Three_project)