如何用一个SQL语句找出离某日最近的一个日期？

[bqj]

表中有一个日期字段LRRQ，如何根据需要，用一个SQL语句，找出距离指定日期最近的上一个录入日期?

[九斤半]

order by datediff(d,LRRQ,指定日期)

[mugua604]

真快!

[九斤半]

create table test(LRRQ datetime)
insert test(LRRQ)
select '2006-8-16' union all
select '2006-8-17' union all
select '2006-8-11' union all
select '2006-8-18' union all
select '2006-8-13' union all
select '2006-8-12'
select * from test
go


create proc sp_dt
@dt datetime
as
select top 1 LRRQ from test
where datediff(d,LRRQ,@dt) >=0
order by datediff(d,LRRQ,@dt)
go

exec sp_dt '2006-8-15'
go

drop proc sp_dt
drop table test
go