本文共 630 字,大约阅读时间需要 2 分钟。
use Per_Rain
go
SELECT CASE WHEN (GROUPING(post_code) = 1) THEN 'ALL'
ELSE ISNULL(post_code, 'UNKNOWN')
END AS post_code,
CASE WHEN (GROUPING(area_code) = 1) THEN 'ALL'
ELSE ISNULL(area_code, 'UNKNOWN')
END AS area_code,
count(1) AS 数量
FROM sht974
GROUP BY post_code, area_code WITH ROLLUP
SELECT CASE WHEN (GROUPING_id(province,city) = 0) THEN CONVERT(varchar(50),city)
WHEN (GROUPING_id(province,city) = 1) THEN CONVERT(varchar(50),province)+'总量'
WHEN (GROUPING_id(province,city) = 2) THEN '总量'
END AS city,
count(1) AS 数量
FROM dbo.Par_Area_Addr where city is not null and province is not null
GROUP BY province,city WITH rollup
转载地址:http://jwbmi.baihongyu.com/