34,587
社区成员
发帖
与我相关
我的任务
分享
SELECT SUM(订单数量) FROM tbl
SELECT ISNULL(SUM(订单数量)) FROM tbl
SELECT ISNULL(SUM(订单数量),0) FROM tbl with(nolock)
SELECT
ISNULL(订单数量, 0)
FROM
(
SELECT
SUM(订单数量) AS 订单数量
FROM
tbl
) t;
SELECT ISNULL(SUM(订单数量),0) FROM tbl