根据员工上下班的等级计算考勤率和迟到次数SQL语句

最新推荐文章于 2022-11-04 21:21:32 发布

lintf1986

最新推荐文章于 2022-11-04 21:21:32 发布

阅读量6k

点赞数

本文链接：https://blog.csdn.net/lintf1986/article/details/3563855

版权

本文提供了一段SQL语句，用于根据员工的上下班时间计算考勤率和迟到次数。示例数据插入了tb5表中，接着通过声明变量设置统计时间范围，然后计算出工作日总数。最后，查询结果展示每个员工的考勤率、迟到次数、早退次数和旷工次数。

摘要由CSDN通过智能技术生成

select 1 as ManaulId,'admin' as UserId,'2008-12-12 08:30:00' as SignTime,'高手帮忙啊'as SignDesc,'10' as SignTag
into tb5
insert into tb5 values(2,'admin','2008-12-12 09:00:00', '急急','21')
insert into tb5 values(3,'zhangsan','2008-12-12 09:00:00','急急','11')
insert into tb5 values(4,'zhangsan','2008-12-12 17:00:00','急急','21')
insert into tb5 values(5,'admin','2008-12-13 09:00:00','急急','11')
insert into tb5 values(6,'admin','2008-12-13 17:30:00','急急','20')

insert into tb5 values(6,'admin','2008-12-15 08:32:00','急急','11')
insert into tb5 values(6,'admin','2008-12-15 17:30:00','急急','20')
insert into tb5 values(6,'zhangsan','2008-12-15 09:30:00','急急','11')