select count(*) from table where abs(datediff(day,时间字段,getdate()))<=5
通过sql语句怎么从表中取当日前后5天过生日的人数啊?谢谢!表中有生日日期字段. declare @Speed int set @Speed=5 select [Date],count(*) ToDayNum from tablename where [Date] between dateadd(dd,@Speed ,getdate()) and dateadd(dd,0-@Speed,getdate())
select * from table where abs(datediff(day,时间字段,getdate()))<=5郁闷,一开始又看错了
declare @Speed int
set @Speed=5
select [Date],count(*) ToDayNum
from tablename
where [Date] between dateadd(dd,@Speed ,getdate()) and dateadd(dd,0-@Speed,getdate())
这样不是今年过生日就没统计啊?