数据库查询数据前20-30行的数据
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
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