日韩av手机在线免费观看_四虎免看黄_亚洲一区中文字幕_亚洲小视频网站_国产一区日韩在线_国产欧美精品一区二区

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

軟件下載吧

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

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

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

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

相關下載

查看所有評論+

網友評論

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

熱門閱覽

最新排行

公眾號

主站蜘蛛池模板: 亚洲一一在线 | 久久久久久久国产 | 免费久久视频 | 午夜网址| 欧美日韩一区在线 | 国产区在线看 | 涩涩视频在线观看免费 | 欧美日韩国产精品一区二区 | 国产精品成av人在线视午夜片 | 一区二区三区久久 | 刘亦菲国产毛片bd | av黄色在线观看 | 黄视频网址 | 欧美久久久 | 久久天堂网 | 欧美日在线 | av手机在线 | 狠狠做深爱婷婷综合一区 | www.亚洲区 | 欧美黑人巨大videos精品 | 日韩国产在线观看 | 亚洲一区二区在线视频 | 久久国产精品一区二区三区 | 国产午夜精品久久 | 亚洲色图网址 | 美女张开腿露出尿口 | 懂色一区二区三区免费观看 | 亚洲欧美国产精品一区二区 | 久久久久久久久中文字幕 | 久久久久久久一级 | 久草网在线视频 | 国产精品1 | 国产精品视频导航 | 欧美激情亚洲激情 | 亚洲国产精品人人爽夜夜爽 | 精品电影 | 欧美日韩在线一区二区三区 | 五月激情综合网 | 国产一区2区 | 国产精品3区 | 一级免费a|