SELECT DISTINCT
    a.ITEM_POPULAR_RANK     RANK
  , a.ITEM_CODE             CODE
  , a.ITEM_NAME             NAME
  , a.RECOMMEND_ITEM_RANK   RCM_RANK
FROM
    ITEM a
ORDER BY
    RANK
  , CODE DESC
;