sql server 时间按照月、周分组

[liangfeilonglfl]

表有个dateTime字段，需要根据年按照月份分组，根据月份按照周进行分组！请问实现这个功能的sql语句是什么呢？

[--小F--]

group by month(时间字段)
group by datepart(wk,时间字段)

[xuexiaodong2009]

3分组取每组的前N个数据

开发中还会遇到需要对某一组数据先分组，然后取每组的前n条记录的情况

不妨试试如下代码

/*

按CurrentNodeLevel列分组，每组按NodeID排序，取出每个组中的前3个元素
*/
declare @temp table (NodeID int, CurrentNodeLevel int ,rowNumber int)--定义临时表
insert into @temp
select NodeID,CurrentNodeLevel,ROW_NUMBER()
OVER ( partition by CurrentNodeLevel
order by NodeID ) as rowNumber
from SchoolTerminalStruct---给临时表中插入数据
select * from @temp where rowNumber<=3--从临时表中取数据
http://user.qzone.qq.com/270769564/infocenter

[Lyongt]

1. 根据年按照月份分组
Select MONTH(dt) as 月份, SUM(数量)
Where Year(dt) = '2011'
Group By Month(dt)

2.根据月份按照周进行分组
Select datepart(Weekd, dt) as 周, SUM(数量)
Where Month(dt) = 6
Group By datepart(Weekd, dt)

[wujianfeng32]

order by year(),month(),datepart(week, ) O(∩_∩)O~

[chenhongjun0624]

http://hi.baidu.com/cc8090123/blog/item/834964366174d193a71e1245.html

[X_0]

select smonth=month(dt),......
from tb
where year(dt)=2011
group by month(dt)

--根據周分組 group by datepart(wk,dt)