select 
 ITEM_POPULAR_RANK as RANK,
 ITEM_CODE as CODE,
 ITEM_NAME as NAME,
 RECOMMEND_ITEM_RANK as RCM_RANK
 From ITEM
 ORDER BY RANK ASC ,CODE DESC