按月份分类汇总
ID订单号日期
1cno001-6-5
2cno001-6-10
3cno002-6-24
4cno001-7-5
5cno001-7-10
6cno002-7-15
得到结果:
订单号月份
cno001-6
cno002-6
cno001-7
cno002-7
分享到:
------解决方案--------------------
----------------------------
--Author:DBA_Huanzj(發糞塗牆)
--Version:
--MicrosoftSQLServer(SP1)-11.0.3000.0(X64)
--Oct1913:38:57
--Copyright(c)MicrosoftCorporation
--EnterpriseEvaluationEdition(64-bit)onWindowsNT6.2(Build9200:)
--
----------------------------
-->测试数据:[huang]
ifobject_id('[huang]')isnotnulldroptable[huang]
go
createtable[huang]([ID]int,[订单号]varchar(6),[日期]datetime)
insert[huang]
select1,'cno001','-6-5'unionall
select2,'cno001','-6-10'unionall
select3,'cno002','-6-24'unionall
select4,'cno001','-7-5'unionall
select5,'cno001','-7-10'unionall
select6,'cno002','-7-15'
--------------开始查询--------------------------
selectdistinct[订单号],SUBSTRING(convert(varchar(4),[日期]),1,4)+'-'+convert(varchar(2),datepart(mm,[日期]))
from[huang]
------解决方案--------------------
selectdistinct订单号,convert(varchar,year(日期))+'-'+convert(varchar,month(日期))
fromTB
------解决方案--------------------
如果觉得《sql月度汇总_按月度分类汇总》对你有帮助,请点赞、收藏,并留下你的观点哦!