oracle处理考勤时间,拆分考勤时间段的sql语句

table CMIS_PERSON_FI_DETAIL_TB ( detail_id NUMBER(20) not null, scan_time DATE, person_fk_id NUMBER(20) not null )

其次,插入数据,插入数据之后的效果是这样的:

最后编写sql进行实现,实现的sql语句如下所示:

select max(a) in_time, max(b) out_time
  from (select decode(mod(rownum, 2), 1, scan_time) a,
               decode(mod(rownum, 2), 0, scan_time) b,
               round(rownum / 2) c
          from CMIS_PERSON_FI_DETAIL_TB)
 group by c
 order by c;

努力 !加油!

oracle处理考勤时间,拆分考勤时间段的sql语句

标签：