select * from (select a.*, rownum num from (XX) a where rownum <= 10 ) b where b.num >= 0;
作者“disablebb”