select * from ( select A.*, rownum rn from ( select * from Table t order by t.bh asc ) A where rownum <=10 )where rn >=0