37,744
社区成员




SELECT PC,E,CASE WHEN TO_DATE('2016-09-01','YYYY-MM-DD') > D THEN D ELSE TO_DATE('2016-09-01','YYYY-MM-DD') END S,
NVL(LEAD(D,1)OVER(PARTITION BY PC ORDER BY D),TO_DATE('2016-10-07','YYYY-MM-DD')) AS N
FROM TMP
WHERE D <= TO_DATE('2016-10-07','YYYY-MM-DD')
ORDER BY PC,S;