select * from (select * from 表名 where ROWNUM <= 10 order by id desc) where ROWNUM <= 10 order by id asc