有个MySQL考勤表，如何统计员工上下班并且带上其他字段？

数据库：

查询语句：

select 
a.teacher_id,a.clock_time as workTime,a.image_url as workImage,b.clock_time as backTime,b.image_url as backImage
from(
    select 
    w1.teacher_id,w1.clock_time,w1.image_url
    from work w1 
    where clock_time=(select min(clock_time) from work w2 where w1.teacher_id=w2.teacher_id)
) a join (
    select 
  w1.teacher_id,w1.clock_time,w1.image_url
    from work w1 
    where clock_time=(select max(clock_time) from work w2 where w1.teacher_id=w2.teacher_id) 
) b on a.teacher_id=b.teacher_id

查询结果：

SQL写的比较乱，仅供参考哈~

mysql一个sql语句不太好处理这个，如果你这个是实际的业务需求，建议在代码逻辑中处理这些数据。