Oracle paging, Fetch period data, top

Oracle does not have the top number feature of SQL Server. Can only be achieved in the form of a period

Code implementation paging, parameters curpage the current page, pageSize per page row, calculate the starting end page number

int startpage = (curPage-1) * pageSize + 1;
int endpage = Curpage * pageSize;

Such as: The current first page, 10 rows per page get 1,10

Current second page, 10 rows per page get 21,20

....

Oracle SQL notation

Take first to tenth data (index starting at 1), equal to TOP 10

SELECT *
From (select T.*, rownum rn from Sys_table t where rownum <= endpage)
where RN >= StartPage

The results are as follows

SELECT *
From (select T.*, rownum rn from Sys_table t where rownum <= 10)
where RN >= 1

Wrong wording

SELECT *
From (select t.* from Sys_users t where rownum <= 10)
where RowNum >= 1

Oracle paging, Fetch period data, top