date 排序

admin

SELECT   DATE_FORMAT(a.face_time, '%Y-%m'),"正常" as face_status,  count(1) as je  from face_daily_logs as a WHERE a.face_status='1' group by DATE_FORMAT(a.face_time, '%Y-%m')

admin

1. SELECT   DATE_FORMAT(a.face_time, '%Y-%m-%d') x, count(1) as y ,"正常" as xy  from face_daily_logs as a WHERE a.face_status='1' group by DATE_FORMAT(a.face_time, '%Y-%m-%d') ORDER BY x
   
2. UNION ALL
   
3. SELECT   DATE_FORMAT(a.face_time, '%Y-%m-%d') x, count(1) as y ,"迟到" as xy  from face_daily_logs as a WHERE a.face_status='2' group by DATE_FORMAT(a.face_time, '%Y-%m-%d') ORDER BY x
   
4. UNION ALL
   
5. SELECT   DATE_FORMAT(a.face_time, '%Y-%m-%d') x, count(1) as y ,"早退" as xy  from face_daily_logs as a WHERE a.face_status='3' group by DATE_FORMAT(a.face_time, '%Y-%m-%d') ORDER BY x
   
6. UNION ALL
   
7. SELECT   DATE_FORMAT(a.face_time, '%Y-%m-%d') x, count(1) as y ,"矿工" as xy  from face_daily_logs as a WHERE a.face_status='4' group by DATE_FORMAT(a.face_time, '%Y-%m-%d') ORDER BY x
   
8. UNION ALL
   
9. SELECT   DATE_FORMAT(a.face_time, '%Y-%m-%d') x, count(1) as y ,"请假" as xy  from face_daily_logs as a WHERE a.face_status='5' group by DATE_FORMAT(a.face_time, '%Y-%m-%d') ORDER BY x
   
10. UNION ALL
    
11. SELECT   DATE_FORMAT(a.face_time, '%Y-%m-%d') x, count(1) as y ,"调休" as xy  from face_daily_logs as a WHERE a.face_status='6' group by DATE_FORMAT(a.face_time, '%Y-%m-%d') ORDER BY x
    
12. 
    
13. 
    

复制代码