110,530
社区成员
发帖
与我相关
我的任务
分享
SELECT cc = ISNULL(SUM(ISNULL(DispatchMQ, 0)),0)
FROM dbo.T_BASE_TDispatchNotice
WHERE DeleteFlag = 0
AND TPSN = 'YKJH201612230000'
GROUP BY TPSN
select ISNULL(cc, 0) from
(
SELECT cc = SUM(ISNULL(DispatchMQ, 0))
FROM dbo.T_BASE_TDispatchNotice
WHERE DeleteFlag = 0
AND TPSN = 'YKJH201612230000'
GROUP BY TPSN
) a
select ISNULL(cc, 0) from
(
SELECT cc = SUM(ISNULL(DispatchMQ, 0)),0)
FROM dbo.T_BASE_TDispatchNotice
WHERE DeleteFlag = 0
AND TPSN = 'YKJH201612230000'
GROUP BY TPSN
) a
select ISNULL(cc, 0) from
(
SELECT cc = SUM(ISNULL(DispatchMQ, 0))
FROM dbo.T_BASE_TDispatchNotice
WHERE DeleteFlag = 0
AND TPSN = 'YKJH201612230000'
GROUP BY TPSN
) a
[/quote]
不行,还是没有显示[/quote]
抱歉!
我刚才测试了一下,问题在于你的 group by 从句。
有 group by 从句的情况下,对 0行的结果集求和,是不会返回 null 的。
应改为:
select ISNULL(sum(cc), 0) from
(
SELECT cc = SUM(ISNULL(DispatchMQ, 0))
FROM dbo.T_BASE_TDispatchNotice
WHERE DeleteFlag = 0
AND TPSN = 'YKJH201612230000'
GROUP BY TPSN
) a
select ISNULL(cc, 0) from
(
SELECT cc = SUM(ISNULL(DispatchMQ, 0))
FROM dbo.T_BASE_TDispatchNotice
WHERE DeleteFlag = 0
AND TPSN = 'YKJH201612230000'
GROUP BY TPSN
) a
[/quote]
不行,还是没有显示