WITH T AS (
SELECT 1 AS CNT, 10 AS CODE, 'APPLE' AS NAME, 1 AS DIV FROM DUAL
UNION SELECT 1, 10, 'APPLE', 2 FROM DUAL
)
SELECT CNT, CODE, NAME,
DECODE(ROW_NUMBER() OVER(PARTITION BY CNT, CODE ORDER BY CNT, CODE), 1, NAME, NAME||'(DUB)') AS RESULT FROM T