日韩小视频-日韩久久一区二区三区-日韩久久一级毛片-日韩久久久精品中文字幕-国产精品亚洲精品影院-国产精品亚洲欧美云霸高清

下載吧 - 綠色安全的游戲和軟件下載中心

軟件下載吧

當前位置:軟件下載吧 > 數據庫 > MS_SQL > SQL開發知識:SQLserver中cube:多維數據集實例詳解

SQL開發知識:SQLserver中cube:多維數據集實例詳解

時間:2024-03-11 15:08作者:下載吧人氣:25

1、cube:生成多維數據集,包含各維度可能組合的交叉表格,使用with 關鍵字連接 with cube

根據需要使用union all 拼接

判斷 某一列的null值來自源數據還是 cube 使用GROUPING關鍵字

GROUPING([檔案號]) = 1 : null值來自cube(代表所有的檔案號)
GROUPING([檔案號]) = 0 : null值來自源數據

舉例:

SELECT * INTO ##GET
FROM
(SELECT *
FROM ( SELECT
CASE
WHEN (GROUPING([檔案號]) = 1) THEN
‘合計’
ELSE [檔案號]
END AS ‘檔案號’,
CASE
WHEN (GROUPING([系列]) = 1) THEN
‘合計’
ELSE [系列]
END AS ‘系列’,
CASE
WHEN (GROUPING([店長]) = 1) THEN
‘合計’
ELSE [店長]
END AS ‘店長’, SUM (剩余次數) AS ‘總剩余’,
CASE
WHEN (GROUPING([店名]) = 1) THEN
‘合計’
ELSE [店名]
END AS ‘店名’
FROM ##PudianCard
GROUP BY [檔案號], [店名], [店長], [系列]
WITH cube
HAVING GROUPING([店名]) != 1
AND GROUPING([檔案號]) = 1 –AND GROUPING([系列]) = 1 ) AS M
UNION
ALL
(SELECT *
FROM ( SELECT
CASE
WHEN (GROUPING([檔案號]) = 1) THEN
‘合計’
ELSE [檔案號]
END AS ‘檔案號’,
CASE
WHEN (GROUPING([系列]) = 1) THEN
‘合計’
ELSE [系列]
END AS ‘系列’,
CASE
WHEN (GROUPING([店長]) = 1) THEN
‘合計’
ELSE [店長]
END AS ‘店長’, SUM (剩余次數) AS ‘總剩余’,
CASE
WHEN (GROUPING([店名]) = 1) THEN
‘合計’
ELSE [店名]
END AS ‘店名’
FROM ##PudianCard
GROUP BY [檔案號], [店名], [店長], [系列]
WITH cube
HAVING GROUPING([店名]) != 1
AND GROUPING([店長]) != 1 ) AS P )
UNION
ALL
(SELECT *
FROM ( SELECT
CASE
WHEN (GROUPING([檔案號]) = 1) THEN
‘合計’
ELSE [檔案號]
END AS ‘檔案號’,
CASE
WHEN (GROUPING([系列]) = 1) THEN
‘合計’
ELSE [系列]
END AS ‘系列’,
CASE
WHEN (GROUPING([店長]) = 1) THEN
‘合計’
ELSE [店長]
END AS ‘店長’, SUM (剩余次數) AS ‘總剩余’,
CASE
WHEN (GROUPING([店名]) = 1) THEN
‘合計’
ELSE [店名]
END AS ‘店名’
FROM ##PudianCard
GROUP BY [檔案號], [店名], [店長], [系列]
WITH cube
HAVING GROUPING([店名]) != 1
AND GROUPING([店長]) != 1 ) AS W )
UNION
ALL
(SELECT *
FROM ( SELECT
CASE
WHEN (GROUPING([檔案號]) = 1) THEN
‘合計’
ELSE [檔案號]
END AS ‘檔案號’,
CASE
WHEN (GROUPING([系列]) = 1) THEN
‘合計’
ELSE [系列]
END AS ‘系列’,
CASE
WHEN (GROUPING([店長]) = 1) THEN
‘合計’
ELSE [店長]
END AS ‘店長’, SUM (剩余次數) AS ‘總剩余’,
CASE
WHEN (GROUPING([店名]) = 1) THEN
‘合計’
ELSE [店名]
END AS ‘店名’
FROM ##PudianCard
GROUP BY [檔案號], [店名], [店長], [系列]
WITH cube
HAVING GROUPING([店名]) = 1
AND GROUPING([店長]) = 1
AND GROUPING([檔案號]) = 1 ) AS K ) ) AS T

標簽MSSQL,SQLServer,技術文檔,數據庫,SQLSERVER

相關下載

查看所有評論+

網友評論

網友
您的評論需要經過審核才能顯示

熱門閱覽

最新排行

公眾號

主站蜘蛛池模板: 亚洲日本va午夜中文字幕一区 | 欧美黑人巨大xxxxxxxx | 五月桃花网婷婷亚洲综合 | 自怕偷自怕亚洲精品 | 精品成人毛片一区二区视 | 日本性色| 久草视频手机在线 | 91香蕉国产观看免费人人 | 末满18以下勿进色禁网站 | 国产欧美亚洲精品一区 | 国内精品视频九九九九 | 日本伊人精品一区二区三区 | 国产自产21区 | 国内久久久 | 九九九九热精品视频 | 成人欧美一区二区三区 | 久久精品综合国产二区 | 欧美特级大片 | 全部在线播放免费毛片 | 真人毛片| 青青自拍视频一区二区三区 | 欧美另类69xxxxx视频 | 日本aaaa级| 韩国三级大全久久网站 | 狠狠色丁香婷婷久久综合不卡 | 久久福利青草精品资源站免费 | 日韩免费观看一级毛片看看 | 在线视频免费国产成人 | 国产91色综合久久免费 | 怡红院在线观看在线视频 | 欧美一级视频免费 | 91麻精品国产91久久久久 | 萌白酱粉嫩jk福利视频在线观看 | 久香草视频在线观看免费 | 九九精品免费观看在线 | 在线观看国产日韩 | 免费人成黄页在线观看视频国产 | 成年人在线观看免费 | 亚洲视频综合网 | 日韩精品网址 | 亚色网址 |