查询中有minus ,union,count 等等操作的时候,数据库会进行sort操作,这点,从解释计划可以看到你的可以写成 select * from (select * where a.ddd=b.citycode and rownum<= 10 order by XXFBSJ desc) minus select * from (select * where a.ddd=b.citycode and rownum<=0 order by XXFBSJ desc) order by xxfbsj desc
select * from (select * where a.ddd=b.citycode and rownum<= 10 order by XXFBSJ desc) minus select * from (select * where a.ddd=b.citycode and rownum<=0 order by XXFBSJ desc)
order by xxfbsj desc