17,086
社区成员
发帖
与我相关
我的任务
分享
select name as "员工姓名",
decode(type,'0','上班','1','下班') as "考勤类型",
max(decode(to_char(dt,'d'),'2',dtime,null)) as "周一",
max(decode(to_char(dt,'d'),'3',dtime,null)) as "周二",
max(decode(to_char(dt,'d'),'4',dtime,null)) as "周三",
max(decode(to_char(dt,'d'),'5',dtime,null)) as "周四",
max(decode(to_char(dt,'d'),'6',dtime,null)) as "周五"
from 考勤表
where dt >= 某一周周一
and dt <= 某一周周五
group name,decode(type,'0','上班','1','下班')