[SQL ] COUNT出來值依序加總

作者: allllllll1 (1l1l1l1l)   2014-01-08 21:15:44
SELECT
YEAR A
MONTH A
COUNT B
FROM X
GROUP BY YEAR A , MONTH A
ORDER BY YEAR A , MONTH A
會出現
A A B
請問有辦法把B欄位依序加總嗎
SUM(COUNT)會出錯

Links booklink

Contact Us: admin [ a t ] ucptt.com