java 对mysql和oracle操作分页排名

业务需求：对某一数据库表进行排名，并且分页后排名不变

mysql：

select 
	s1.area_code
	,(select count(DISTINCT(s2.area_code))
 	from sys_area s2 where s2.area_code >= s1.area_code) 			as Rank 
 from sys_area s1 
 where  s1.area_level = 3 
 ORDER BY Rank 
 limit 10, 10

oracle:

select employee_name,
       money,
       rank() over(order by money) rank,
       dense_rank() over(order by money) dense_rank,
       row_number() over(order by money) row_number
  from salary`