【建表语句】
CREATE TABLE sumtest ( Id int(11) NOT NULL AUTO_INCREMENT, CardName longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, Amount1 decimal(65, 30) NULL DEFAULT NULL, Amount2 decimal(65, 30) NULL DEFAULT NULL,
PRIMARY KEY (Id) USING BTREE
) ENGINE = oceanbase CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
【问题SQL】
SELECT
SUM( z.QiMoAmount ) AS QiMoAmount
FROM
(
SELECT
COALESCE(a.Amount1,0) - COALESCE (a.Amount2,0) AS QiMoAmount
FROM
(
SELECT
SUM( COALESCE ( Amount1, 0 ) ) AS Amount1,
SUM( COALESCE ( Amount2, 0 ) ) AS Amount2,
CardName AS CardBrandName
FROM
sumtest
GROUP BY
CardName
) AS a
WHERE
1 = 1
) AS z;