Question

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

要把表的记录列出来并按某几列小计，最后一行是合计行，请问题在SQL SERVER 2000中如何写

Answer 1

--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

Answer 2

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

Answer 3

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