求一个查询语句！

[Rex_love_Burger]

有如下数据表：
STCD varchar
DYP decimal
TM datetime

请问如何查询某STCD对应的，每天(该表中包含的所有日期)中离上午8点最近的一条数据的DYP的值？

十分感谢!

[mxbhot85]

select *
from tbl_date
where stcd = ( select top 1 stcd
from tbl_date t
order by abs(datename(hh,t.tm)*60+datename(mi,t.tm)-480))

[水族杰纶]

--try
select *
from tb t
where TM=(select top 1 tm
          from tb
          where STCD=t.STCD 
          order by abs(datediff(hour,tm,convert(varchar(10),getdate(),120)+' 08:00:00')))

[情殇无限]

select dyp  from (
Select stcd,dyp,tm,rank() 
over(partition by convert(varchar(10),tm,120) order by datediff(minute,tm,convert(varchar(10),tm,120)+' 08:00:00'))
rn from 表) x
where abs(rn)=1

[情殇无限]

select dyp  from (
Select stcd,dyp,tm,rank() 
over(partition by convert(varchar(10),tm,120) order by datediff(minute,tm,convert(varchar(10),tm,120)+' 08:00:00') desc)
rn from #tb) x
where abs(rn)=1

排序错了

[情殇无限]

select *  from (
Select stcd,dyp,tm,rank() 
over(partition by stcd ,convert(varchar(10),tm,120) order by datediff(minute,tm,convert(varchar(10),tm,120)+' 08:00:00') desc)
rn from #tb) x
where abs(rn)=1

[Rex_love_Burger]

谢谢大家，非常感谢，结贴