17,081
社区成员
发帖
与我相关
我的任务
分享
select t.empno, t.kq_date, max(decode(rn, 1, t.kq_time)) time1, max(decode(rn, 2, t.kq_time)) time2, max(decode(rn, 3, t.kq_time)) time3, max(decode(rn, 4, t.kq_time)) time4, max(decode(rn, 5, t.kq_time)) time5, max(decode(rn, 6, t.kq_time)) time6 from (select t.*, row_number() over(partition by t.empno,t.kq_date order by t.kq_time) rn from t) t group by t.empno, t.kq_date;
select t.empno,
t.kq_date,
max(decode(rn, 1, t.kq_time)) time1,
max(decode(rn, 2, t.kq_time)) time2,
max(decode(rn, 3, t.kq_time)) time3,
max(decode(rn, 4, t.kq_time)) time4,
max(decode(rn, 5, t.kq_time)) time5,
max(decode(rn, 6, t.kq_time)) time6
from (select t.*,
row_number() over(partition by t.empno order by t.kq_time) rn
from t) t
group by t.empno, t.kq_date;