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

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

軟件下載吧

當前位置:軟件下載吧 > 數據庫 > 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

相關下載

查看所有評論+

網友評論

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

熱門閱覽

最新排行

公眾號

主站蜘蛛池模板: 91久久香蕉 | 国产高清在线视频 | 九九99re在线视频精品免费 | 欧美+日本+国产+在线观看 | 国产精品九九九久久九九 | 欧美xxx高清 | 欧美最大成人毛片视频网站 | 精品国产a| 影院成人区精品一区二区婷婷丽春院影视 | 国产精品96久久久久久久 | 97久久精品国产精品青草 | 一区二区国产在线播放 | 一级片网站在线观看 | 国产女王vk | 亚洲欧美在线视频 | 亚洲综合一 | 5x社区直接进入一区二区三区 | 亚洲精品一区二区三区www | 亚洲三级小视频 | 亚洲一区在线观看视频 | 狠狠综合久久久久综合 | 韩日一级视频 | 久草在线视频在线 | 日韩性黄色一级 | 大片毛片女女女女女女女 | 欧美les视频xxxx在线观看 | 中文字幕亚洲综合久久男男 | 九九精彩视频在线观看视频 | 2020黄网| 日本免费在线 | 中文字幕福利片 | 香港aa三级久久三级 | 黄色三级免费网站 | 久久99热只有视精品6国产 | 久久久久久久岛国免费观看 | 亚洲一级毛片免费观看 | 特黄特色大片免费播放路01 | 国产一区二区免费在线 | 国产国语在线播放视频 | 欧美乱爱 | 成人性视频在线三级 |