SQLè¯å¥ +
æ°æ®éè§è¡¨ï¼åæ°æ®éè§è¡¨éå¢å â计ç®é¡¹å段âã
SQLè¯å¥ï¼
select å¹´,æ,产å,åæ ¼å¤å®,sum(å
¥åºæ»é) from (select year(æ¥æ) as å¹´,month(æ¥æ) as æ,* from [ç产æ°æ®$]) group by å¹´,æ,产å,åæ ¼å¤å®