...年分的这个日期前十天的数据,能不能在一个SQL语句中实现呢答:select id,name,insertdate from (select *,datepart(yyyy,insertdate) as year from test) as A where DATEDIFF(day,insertdate,STR(year,4,0)+'-3-5')>0 and DATEDIFF(day,insertdate,STR(year,4,0)+'-3-5')<=10 order by year ...