[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