[]oracle to query a record of a specified number of rows

Oracle uses virtual column rownum to query the number of records between a specified number.

The first line of Rownum=1

For example, we want to query the first five records, you can use

SELECT * FROM table name where rownum<5.

But if we use rownum>5, we will make mistakes, and then we have to change the method.

Select Column name from
(select RowNum r, column name from EMP)
where r>5

For example, if we want to query an EMP table for a salary of 6-9 of the employees, then

Select Ename,sal from
(
Select Ename,sal,rownum r from (select Ename,sal from emp order BY sal Desc)
)
where R>5 and r<10

[]oracle to query a record of a specified number of rows