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

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

軟件下載吧

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

相關下載

查看所有評論+

網友評論

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

熱門閱覽

最新排行

公眾號

主站蜘蛛池模板: 亚洲欧美成人网 | 午夜影院在线免费 | 亚洲精品国产综合99久久一区 | 中文精品久久久久国产网址 | 久草热久 | 夜鲁夜鲁夜鲁在线观看福利 | 成人久久18免费软件 | a级片黄色片 | 欧美日韩中 | 成人www| 手机在线精品视频每日更新 | 国产码一区二区三区 | 亚洲作爱视频 | 欧美特黄一级高清免费的香蕉 | 精品久久精品久久 | 美女一级ba大片免色野外 | 国产成人一区二区三区免费观看 | 中国一级做a爱片免费 | 国产精自产拍久久久久久 | 99精品观看 | 成年性午夜免费视频网站不卡 | 欧美毛片| 国产丝袜不卡一区二区 | 国产亚洲精品日韩已满十八 | 国产一区二区三区免费播放 | 亚洲男人的天堂久久香蕉 | 香蕉久久综合精品首页 | 日本波多野结衣视频 | 美女免费黄视频 | 亚洲视频在线播放 | 欧美三级欧美成人高清www | 美女网站色免费 | 亚洲成在人线免费视频 | 久久中文字幕日韩精品 | 亚洲欧美日韩综合久久久久 | 成人免费视频一区二区 | 久久久久久久久综合 | 538在线视频二三区视视频 | 欧美日韩一区二区三区在线 | 玖玖精品视频在线观看 | 日本高清在线中文字幕网 |