作者allllllll1 (1l1l1l1l)
看板Database
标题[SQL ] COUNT出来值依序加总
时间Wed Jan 8 21:15:44 2014
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)会出错
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 122.116.29.206