WITH EMPCTE (EMP_CODE, EMP_NAME, REMARK)
AS ( SELECT EMP_CODE,
EMP_NAME,
REMARK,
BIRTHDATE,
JOINDATE
FROM EMPMAST
)
SELECT EMP_CODE,
EMP_NAME,
REMARK
FROM EMPCTE AS CTE
AS ( SELECT EMP_CODE,
EMP_NAME,
REMARK,
BIRTHDATE,
JOINDATE
FROM EMPMAST
)
SELECT EMP_CODE,
EMP_NAME,
REMARK
FROM EMPCTE AS CTE
No comments:
Post a Comment