select * from ( select rownum r,* from table where rownum <= 20 order by 成绩 ) where r >= 10
------------------------------------------------------------------------------ Blog: http://blog.csdn.net/tianlesoftware 网上资源: http://tianlesoftware.download.csdn.net 相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx Q Q 群:62697716 select 成绩 from ( select rownum AS rowmm,成绩 from ( select 成绩 from 成绩表 order by 成绩) where rownum <20 ) where rowmm>10