SELECT YEAR([time]) AS 年,MONTH([time]) as 月,SUM([money]) as 销售总额 FROM table_Name WHERE YEAR(GETDATE())=YEAR([time]) GROUP BY YEAR([time]),MONTH([time])
需要加两个字段,分别是年份和月份,数据来源是通过time转换而来,然后就可以愉快的sum ,group by 了
56,803
社区成员
56,752
社区内容
加载中
试试用AI创作助手写篇文章吧