SELECT
DECODE(ROW_NUM,ROW_RANK,SAL,NULL) AS AVOID_DUPLICATE
(
)
Wednesday, March 13, 2024
Remove duplicate row with rank() analytical function.
)
Subscribe to:
Posts (Atom)
)
)
SELECT
DECODE(ROW_NUM,ROW_RANK,SAL,NULL) AS AVOID_DUPLICATE
(