Wednesday, March 13, 2024

Remove duplicate row with rank() analytical function.

 

SELECT

    DECODE(ROW_NUM,ROW_RANK,SAL,NULL) AS AVOID_DUPLICATE

(


)

No comments:

Post a Comment