怎么得到查询一天最早时间和最晚时间

Question

Answer 1

select top 1 employee_Cheak as '最早时间',t1.最晚时间 from employeecheak ,
(select top 1 employee_Cheak as '最晚时间' from employeecheak
where employee_Cheak >CONVERT(varchar(10), getdate(), 120 )
order by employee_Cheak desc) t1
where employee_Cheak >CONVERT(varchar(10), getdate(), 120 )
order by employee_Cheak asc