服务器维护网站维护数据维护系统安全配置
专业定制网站企业建站一条龙、软件定制开发、系统集成
稳定虚机备案一条龙，稳定快捷通道
服务理念诚信守诺客户至上专业精神专心贯注

SQL 之Group by with Rollup效果(3)

作者：黑客防线网安SQL维护基地来源：黑客防线网安SQL维护基地浏览次数：0

本篇关键词：效果 Lb T1

黑客防线网安网讯：　　max(line) , max(title_code) , sum(headcount) as Headcounts from #tmpA group by dept , sect with rollup sect sect Headcounts --...

　　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