select * from (

select row from tab where rownum<10) where rownum>5;
复制

除了rownum之外，还可以使用offset…fetch…,例如：

select snap_id from dba_hist_tbspc_space_usage 
group by snap_id order by snap_id desc  
offset 0 rows fetch first 1 rows only;
复制

语法截图：

官网地址：https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/SELECT.html#GUID-CFA006CA-6FF1-4972-821E-6996142A51C6