17,086
社区成员
发帖
与我相关
我的任务
分享
SELECT employee_id, MAX(post_name_redundancy150101), MAX(post_name_redundancy151231)
FROM (
SELECT a.employee_id, a.begin_date, nvl(a.end_date, SYSDATE) end_date, a.post_name_redundancy,
CASE
WHEN DATE '2015-01-01' BETWEEN a.begin_date AND nvl(a.end_date, SYSDATE) THEN
a.post_name_redundancy
END post_name_redundancy150101,
CASE
WHEN DATE '2015-12-31' BETWEEN a.begin_date AND nvl(a.end_date, SYSDATE) THEN
a.post_name_redundancy
END post_name_redundancy151231
FROM test01 a)
GROUP BY employee_id;