SQL 之Group by with Rollup 的效果

2008-04-18 09:16:42　来源:中国自学编程网　作者:佚名点击:

建立示例过程，以演示Group by with Rollup 的效果

　　max(line) , max(title_code) ,
sum(headcount) as Headcounts
from #tmpA
group by dept , sect  with rollup

sect            sect                           Headcounts
--------------- -------------------- ---- ---- -----------
DA              S1                   Lb   T2   12
DA              S2                   Lb   T1   6
DA              total ( by Dept ) :  Lb   T2   18
DB              S1                   Lb   T1   3
DB              S2                   Lb   T1   6
DB              total ( by Dept ) :  Lb   T1   9
DC              S1                   La   T1   3
DC              S2                   Lb   T1   3
DC              total ( by Dept ) :  Lb   T1   6
Grant total  :                       Lb   T2   33

9 7 3 1 2 3 4 8 :