SELECT
CenterCD
,UseUnitCD
,SUM(UseUnitUnitPrice) 'totaladvance'
, GROUPING(UseUnitCD) 'grp'
FROM dbo.T_MMaterialGroupUnitPrice_SLS
GROUP BY CenterCD,UseUnitCD
WITH ROLLUP
SELECT
CenterCD
,UseUnitCD
,UseCD
,SUM(UseUnitUnitPrice) 'total advance'
,GROUPING(UseCD) 'grp'
FROM dbo.T_MMaterialGroupUnitPrice_SLS
GROUP BY CenterCD,UseUnitCD,UseCD
WITH ROLLUP
SQL-同时看到明细和合计
最新推荐文章于 2023-03-09 12:19:55 发布