WITH t AS ( SELECT '사과' Fruit, '2019' yyyy, 2 cnt FROM dual UNION ALL SELECT '사과', '2018', 1 FROM dual UNION ALL SELECT '배 ', '2018', 1 FROM dual UNION ALL SELECT '오이', '2017', 1 FROM dual ) SELECT * FROM (SELECT Fruit, yyyy, cnt , ROW_NUMBER() OVER(PARTITION BY Fruit ORDER BY yyyy DESC) rn FROM t WHERE yyyy <= :v_yyyy ) WHERE rn = 1 ;