SUM(A)+SUM(B) = SUM(A+B). • Define all NUMERIC columns as NOT NULL DEFAULT 0. • Use the ZEROIFNULL function nested within the aggregate function to convert any nulls to zeros for the computation, for example SUM(ZEROIFNULL(x) + ZEROIFNULL(y))
如何解決 SUM(A) + (SUM B) != SUM (A+B)
最新推荐文章于 2022-01-26 19:24:49 发布