题解 | 更新员工信息表
更新员工信息表
https://www.nowcoder.com/practice/1eb20d4bf7c5443da7b84105372c9070
WITH T1 AS( SELECT *,ROW_NUMBER() OVER(PARTITION BY EMPLOYEE_ID ORDER BY UPDATE_DT DESC) AS RN FROM EMPLOYEE_UPDATE) SELECT A.EMPLOYEE_ID,IF(UPDATE_DT>LAST_UPDATE_DT,NEW_POSITION,POSITION) AS POSITION,IF(UPDATE_DT>LAST_UPDATE_DT,UPDATE_DT,LAST_UPDATE_DT) AS LAST_UPDATE_DT FROM EMPLOYEE_INFO A JOIN T1 B ON A.EMPLOYEE_ID=B.EMPLOYEE_ID WHERE B.RN=1
查看8道真题和解析