摘要:
方式1SELECT a.EmpNo,a.AttDate,CASE WHEN (a.TStTime>=a.DinStTime and a.TStTime=a.DinStTime and a.TEnTime =a.DinStTime and a.TStTime=a.DinStTime and a.TEnTime <= a.DinEnTime) THEN a.DinStTime ELSE a.TEnTime END AS REnTime,b.LTimes FROM leave_view_temp2 a INNER JOIN (SELECT EmpNo,AttDate,count(EmpN 阅读全文