查询表中第五条到第十条的数据

查询表中第五条到第十条的数据

table：serv_history_517

查询前十条数据：
Select * from serv_history_517 where rownum<11；查询后十条数据：
select * from (select rownum no ,serv_id from serv_history_517 ) where no>10查询第五条到第十条的数据（有六条数据）：
select * from (select rownum no ,serv_id from serv_history_517 ) where no>4 and no <11;