求sql语句如何按月搜索数据库

来源：百度知道 编辑：UC知道 时间：2024/05/29 00:43:40
addtime num
1987-11-1 2
1987-11-23 4
1967-1-1 3
1980-11-1 4
。。。。

，怎样按让他搜索数据库，按月自动求和输出
addtime sum（ num）
1987-11 6
1967-1 3
1980-11 4
。。。-

select substring(convert(varchar(20),cast(addtime as datetime),120),1,7),sum(num)
from table
group by 1
order by 1

select cast(year(addtime) as varchar(4))+'-'+cast(month(addtime) as varchar(2)) as addtime,sum(num) as num from 表 group by cast(year(addtime) as varchar(4))+'-'+cast(month(addtime) as varchar(2))

以上，希望对你有所帮助！

SELECT CAST(DATEPART(year, addtime) AS varchar) + '-' + CAST(DATEPART(month, addtime) AS varchar) AS Expr1, SUM(num) AS Expr2
FROM Table_6
GROUP BY CAST(DATEPART(year, addtime) AS varchar) + '-' + CAST(DATEPART(month, addtime) AS varchar)
这个是正解