SQL Server中Rollup关键字使用技巧.docVIP

SQL Server中Rollup关键字使用技巧 首先创建测试表、添加数据。 create?table?#t(a?int,b?int,c?int,d?int,e?int) insert?into?#t?values(1,2,3,4,5) insert?into?#t?values(1,2,3,4,6) insert?into?#t?values(1,2,3,4,7) insert?into?#t?values(1,2,3,4,8) insert?into?#t?values(1,3,3,4,5) insert?into?#t?values(1,3,3,4,6) insert?into?#t?values(1,3,3,4,8) insert?into?#t?values(1,3,3,4,7) insert?into?#t?values(2,2,2,4,5) insert?into?#t?values(2,2,3,4,6) insert?into?#t?values(2,2,4,4,7) insert?into?#t?values(2,2,5,4,8) insert?into?#t?values(2,3,6,4,5) insert?into?#t?values(2,3,3,4,6) insert?into?#t?values(2,3,3,4,8) insert?into?#t?val