SQL server与Oracle分页语句

 SQL server

SELECT id,simple_name,fan_name,en_name,orders,focus,high 
FROM Test_Gyd_table 
order by id
offset 0 rows
fetch next 5 rows only ;

offset {偏移量} rows fetch next {pageSize} rows only;

Oracle

select * 
from(
select FirstName, LastName, personId
from Person   
order by personId DESC 
)
where rownum between 0 and 1

where rownum between  {偏移量} and {偏移量+pageSize}

rownum相当于Oracle为查询结果自带的序号列，可以跟在select后进行查询显示