sqlserve语句查找筛选数据

从周数据表里里返回一段时间内每个月最后一周的那一条数据 ，用sqlserver怎么写

这感觉要用存储过程解决啊。

忘记加前面两个字段了，如下：

  select * from TableName t left join
(
select a.Provinceid,a.company,a.nian,a.yue,max(a.zhou) as Mzhou 
from 
(select * from TableName where reportdate between '2015-1-1 0:00:00' and ''2015-12-1 0:00:00'') as a 
group by a.Provinceid,a.company,a.nian,a.yue ) b 
on t.Provinceid=b.Provinceid and t.company=b.company and t.nian=b.nian and t.yue=b.yue and t.zhou=b.Mzhou

如下，没有环境调试，你自己试下。

 select * from TableName t left join
(
select a.Provinceid,a.company,a.nian,a.yue,max(a.zhou) as Mzhou 
from 
(select * from TableName where reportdate between '2015-1-1 0:00:00' and ''2015-12-1 0:00:00'') as a 
group by a.Provinceid,a.company,a.nian,a.yue ) b 
on t.nian=b.nian and t.yue=b.yue and t.zhou=b.Mzhou