随笔分类 -  IUCO

查询卡余额
摘要：select m.join_id, m.cardbalance,e.emp_id,e.emp_fname,d.depart_name from mealrecords m inner join ( select join_id,max(cardindex) cardindex from mealre 阅读全文
posted @ 2021-08-12 09:03 游工 阅读(48) 评论(0) 推荐(0)
查询设备机号、名单
摘要：select clock_id as 机号,COUNT(card_id)as 人数 from AssignEmpOther where photo_downstate=4 group by clock_id 阅读全文
posted @ 2021-08-12 08:57 游工 阅读(391) 评论(0) 推荐(0)
查询人脸机分配名单数量
摘要：select clock_id as 机号,COUNT(card_id)as 人数 from AssignEmpOther where photo_downstate=4 group by clock_id 阅读全文
posted @ 2020-07-03 10:48 游工 阅读(5) 评论(0) 推荐(0)