1:Select 名称,规格,sUM(数量) fROM TB Where year(时间) = @year and month(时间)=@month group by 名称,规格
2:Select 名称,规格,sUM(数量) fROM TB Where 时间 between @sdate and @edate group by 名称,规格
2:Select 名称,规格,sUM(数量) fROM TB Where 时间 between @sdate and @edate group by 名称,规格
谢谢!但year(时间)和month(时间)中的“时间”具体怎样写,如按年怎样写?按季或按月又怎么写?
2按月:Select 名称,规格,sUM(数量) fROM TB Where month(时间) >=1 and month(时间) <=12 group by 名称,规格,month(时间)
3:Select 名称,规格,sUM(数量) fROM TB Where detepart(quarter,时间) >=1 and detepart(quarter,时间) <=4 group by 名称,规格,detepart(quarter,时间)1:
Select 名称,规格,sUM(数量) fROM TB Where 时间 between @sdate and @edate group by 名称,规格,year(时间)
2:Select 名称,规格,sUM(数量) fROM TB Where 时间 between @sdate and @edate group by 名称,规格,month(时间)
3:Select 名称,规格,sUM(数量) fROM TB Where 时间 between @sdate and @edate group by 名称,规格,detepart(quarter,时间)
select 名称,规格,sum(数量) from 表 where (datepart(yy,日期) between (随选) and (随选))or (datepart(mm,日期) between (随选) and (随选) )
group by 名称,规格
group by 名称,规格,(datepart(yy,日期)2 select 名称,规格,sum(数量) from 表 where (datepart(mm,日期) between (随选) and (随选) )
group by 名称,规格,(datepart(mm,日期)3 select 名称,规格,sum(数量) from 表 where (datepart(qq,日期) between (随选) and (随选) )
group by 名称,规格,datepart(qq,日期)