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

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

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

<span style="color: #0000ff;">select</span> <span style="color: #ff00ff;">max</span>(a) in_time, <span style="color: #ff00ff;">max</span><span style="color: #000000;">(b) out_time
  </span><span style="color: #0000ff;">from</span> (<span style="color: #0000ff;">select</span> decode(mod(rownum, <span style="color: #800000; font-weight: bold;">2</span>), <span style="color: #800000; font-weight: bold;">1</span><span style="color: #000000;">, scan_time) a,
               decode(mod(rownum, </span><span style="color: #800000; font-weight: bold;">2</span>), <span style="color: #800000; font-weight: bold;">0</span><span style="color: #000000;">, scan_time) b,
               </span><span style="color: #ff00ff;">round</span>(rownum <span style="color: #808080;">/</span> <span style="color: #800000; font-weight: bold;">2</span><span style="color: #000000;">) c
          </span><span style="color: #0000ff;">from</span><span style="color: #000000;"> CMIS_PERSON_FI_DETAIL_TB)
 </span><span style="color: #0000ff;">group</span> <span style="color: #0000ff;">by</span><span style="color: #000000;"> c
 </span><span style="color: #0000ff;">order</span> <span style="color: #0000ff;">by</span> c;

努力 !加油!

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

标签：