distinct 与order by 一起用

distinct 后面不要直接跟Order by , 如果要用在子查询用用order by .