select item_id from CMP_ITEM_DEF_TD order by item_code // ok
select distinct item_id from CMP_ITEM_DEF_TD order by item_code // error
抛出如下异常:
如果指定了 SELECT DISTINCT,那么 ORDER BY 子句中的项就必须出现在选择列表中
select distinct item_id , item_code from CMP_ITEM_DEF_TD order by item_code // OK