想把以下的语句，mysql移植到Oracle，其中的limit offset怎么改呢？

我来答

2021-10-27

SELECT (SELECT DISTINCT Salary
        FROM Employee
        ORDER BY Salary DESC
        LIMIT 1 OFFSET 1) AS SecondHighestSalary

我来答

添加附件

问题补充

2条回答

默认

最新

select salary from (

select salary ,rownum rn from (

SELECT DISTINCT Salary
FROM Employee
ORDER BY Salary DESC))

where rn between 1 and 2

有用 2

题主

2021-10-27

谢谢

在oracle12c以后，支持如下写法

select * from emp fetch first 10 row only;

select * from emp order by sal first fetch 5 row only;

select * from emp order by sal offset 3 rows fetch next 5 rows only;

select * from emp fetch next 0.1 percent rows only;

有用 0

回答交流

提交

问题信息

请登录之后查看

邀请回答

暂无人订阅该标签，敬请期待~~

墨值悬赏