sql聚合，总跳不出这个坎

[luomingliang1026]

select
fw.fund_id
--,fw.statistic_date
,min(abs(datediff(day,fw.statistic_date,'2010-11-30'))) dif
from t_fund_week_statistic fw
where fw.statistic_date between '2010-11-23' and '2010-12-07'
group by fw.fund_id
order by fund_id
大家帮忙看下上面的程序，我想对fund_id聚合，得到最靠近11月底的时间点，但有需要输出哪个时间点fw.statistic_date，
假如一起聚合fund_id和fw.statistic_date结果又不是单个fund_id对于一个fw.statistic_date

怎么处理啊，跪求高手！！

[-晴天]

select * from t_fund_week_statistic a
where statistic_date between '2010-11-23' and '2010-12-07'
and not exists(select 1 from t_fund_week_statistic where abs(datediff(s,statistic_date,'2010-12-01'))<abs(datediff(s,a.statistic_date,'2010-12-01')))

[--小F--]

select
 * 
from
 t_fund_week_statistic t
where
 statistic_date between '2010-11-23' and '2010-12-07'
and
 abs(datediff(s,statistic_date,'2010-12-01'))=(select min( abs(datediff(s,statistic_date,'2010-12-01'))) from t_fund_week_statistic fund_id
=t.fund_id)

[luomingliang1026]

都不对，一个日期要与一个fund_id对应的

[luomingliang1026]

这样岂不跟fund_id无关了