SELECT A, B, C, SUM(B + C) AS D
FROM A
WHERE (A <> 'A3')
GROUP BY A, B, C
UNION
SELECT A, B, C, 8 AS D
FROM A
WHERE (A = 'A3')
GROUP BY A, B, C
ORDER BY A可以是可以,不过应该还有更好的方法。呵呵~~我暂时想到这一条。
FROM A
WHERE (A <> 'A3')
GROUP BY A, B, C
UNION
SELECT A, B, C, 8 AS D
FROM A
WHERE (A = 'A3')
GROUP BY A, B, C
ORDER BY A可以是可以,不过应该还有更好的方法。呵呵~~我暂时想到这一条。
FROM A