作者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