Question

sql有一个表 1-12个月 求1-5月的数据汇总

Answer 1

需要用到函数sum
select sum(number) from table where month >=1 and month <=5
除了用大于等于和小于等于判断时间范围，还可以用between and判断。
祝好运，望采纳。

Answer 2

select sum(amt) from table where month between 1 and 5 amt为你要汇总的value