Oracle:Ora-01791 不是Selected表达式

SELECT DISTINCT a.id from portal_site_part p  left join portal_eai_app a on a.ID=p.BUSINESS_ID where p.id in(1003,1005) ORDER by a.PRIORITY ASC;

原来是order by 后排序的字段没有出现在distinct中，在distinct 后加上a.PRIORITY就可以了，如下所示：

SELECT DISTINCT a.id,a.PRIORITY from portal_site_part p  left join portal_eai_app a on a.ID=p.BUSINESS_ID where p.id in(1003,1005) ORDER by a.PRIORITY ASC;