FROM (
SELECT ROWNUM AS RANK,YEAR, ID,COL1,COL2,DATE
FROM EMPLOYEE
WHERE YEAR IN (‘2008′)
ORDER BY DATE DESC
) A
WHERE RANK=1
UNION
SELECT ROWNUM AS RANK, ID,YEAR, COL1,COL2,DATE
FROM
(
SELECT ROWNUM AS RANK1, YEAR, COL1,COL2, DATE
FROM EMPLOYEE
WHERE YEAR IN (‘2009′)
ORDER BY DATE DESC
)
WHERE RANK=1
)