数据库查询数据前20-30行的数据

嘻哈小王 / 2025-02-18 / 原文

oracle写法:

select *
  from (select fu.display_name, row_number() over(order by fu.id) pageId
          from fnd_user fu) t
 where t.pageId between 20 and 30

mysql写法:
select * from fnd_user limite 30,10