select * from (select t.*,row_number() over(order by t.ownerid desc )r from UUMOWNERS t) where r between 1 and 2
--通用语法: 解析函数() over(partition by 字段 order by 字段)
oracle使用over进行分页
最新推荐文章于 2023-03-14 14:14:41 发布
select * from (select t.*,row_number() over(order by t.ownerid desc )r from UUMOWNERS t) where r between 1 and 2
--通用语法: 解析函数() over(partition by 字段 order by 字段)