sql - 以半月,每月 分组

按半月:完整代码:

SELECT siteNumber [站点],

CONVERT(VARCHAR(7),day,120)+'-'+

case when day(day) between 1 and 15 then '上半月' else '下半月' end [半月],

SUM(rainVal) [半月降雨量]

FROM r a

GROUP BY CONVERT(VARCHAR(7),day,120)+'-'+

case when day(day) between 1 and 15 then '上半月' else '下半月' end,

siteNumber

order by siteNumber, CONVERT(VARCHAR(7),day,120)+'-'+

case when day(day) between 1 and 15 then '上半月' else '下半月' end

按月分组:

select year(ordertime) 年，

month(ordertime) 月,

sum(Total) 销售合计

from 订单表

group by year(ordertime)，

month(ordertime