sql server 的列表并分组小计、合计的问题

--TB
ID ITEM
------------------------------ -----------
8 3
9 4
10 5
12 6
--
SELECT ISNULL(CAST(ID AS VARCHAR),'ALL')ID,SUM(ITEM)ITEM FROM TB GROUP BY ID WITH CUBE
ID ITEM
------------------------------ -----------
8 3
9 4
10 5
12 6
ALL 18

select * from tb
group by 主键 with cube
with cube 要详细一点~

select * from tb
group by 主键 with rollup
或者
select * from tb
group by 主键 with cube
with cube 要详细一点~