回答:select a.name,a.DEPTNAME,
max(case when CONVERT(varchar(10), CHECKTIME, 108)<'11:30:00' then CONVERT(varchar(10), CHECKTIME, 108) else '' end )开始时间 ,
max(case when CONVERT(varchar(10), CHECKTIME, 108)>'11:45:00' then CONVERT(varchar(10), CHECKTIME, 108) else '' end )结束时间 ,
convert(varchar(10),a.CHECKTIME,120) as 设计需求
from kqst a
group by a.name,a.DEPTNAME,convert(varchar(10),a.CHECKTIME,120)