22,207
社区成员
发帖
与我相关
我的任务
分享
USE test
GO
SELECT COALESCE(SUM(col),1) AS sum_result FROM (SELECT CAST(NULL AS INT) AS col WHERE 1=2 ) AS t
SELECT COALESCE(COUNT(col),1) AS count_result FROM (SELECT CAST(NULL AS INT) AS col WHERE 1=2 ) AS t
SELECT COALESCE(MAX(col),1) AS max_result FROM (SELECT CAST(NULL AS INT) AS col WHERE 1=2 ) AS t
SELECT COALESCE(MIN(col),1) AS mix_result FROM (SELECT CAST(NULL AS INT) AS col WHERE 1=2 ) AS t
SELECT COALESCE(AVG(col),1) AS avg_result FROM (SELECT CAST(NULL AS INT) AS col WHERE 1=2 ) AS t
/*
sum_result
-----------
1
(1 個資料列受到影響)
count_result
------------
0
(1 個資料列受到影響)
max_result
-----------
1
(1 個資料列受到影響)
mix_result
-----------
1
(1 個資料列受到影響)
avg_result
-----------
1
(1 個資料列受到影響)
*/
SELECT COALESCE(col,1) AS nl_result FROM (SELECT CAST(NULL AS INT) AS col WHERE 1=2 ) AS t
GROUP BY col
/*
result
-----------
(0 個資料列受到影響)
*/