select ITEM_POPULAR_RANK as RANK,ITEM_CODE as CODE, ITEM_NAME as NAME,RECOMMEND_ITEM_RANK as RCM_RANK from ITEM
group by  ITEM_POPULAR_RANK,ITEM_CODE ORDER BY ITEM_POPULAR_RANK asc,ITEM_CODE desc