110,533
社区成员
发帖
与我相关
我的任务
分享
select min(abs(DATEDIFF(minute,CAST(c.plantime AS smalldatetime ),'1900-01-01 0:0'))) AS
plantime1,c.plantime
from LP_DAYCLASSDTL a,LP_CLASSROAD b,LP_TIMEPLAN c
where a.dayclassid = '1'
and a.classid = b.classid
and b.lpno = c.lpno
and b.potno = c.potno
and b.lpno = '74'
group by c.plantime
order by plantime1 asc