如何使用Rownum从表中选择第n行

Question

SELECT emp_id INTO high_payed_emp_id
FROM (SELECT emp_id  from cursor_table ORDER BY emp_salary DESC)
WHERE rownum = 1;

我正在尝试获得Max的EMP_ID。付费员工错误消息：ORA-00905：缺少关键字

Answer 1

而不是使用 FETCH FIRST，如果有两个（或更多），则添加 WITH TIES均具有相同的最大薪水：

：

SELECT emp_id
FROM cursor_table
ORDER BY emp_salary DESC
FETCH FIRST 1 ROW WITH TIES

Answer 2

SELECT emp_id INTO high_payed_emp_id
FROM (SELECT emp_id  from cursor_table 
WHERE emp_salary = (select max(emp_salary) from cursor_table))a

Answer 3

yor需要正确的SQL语法

 insert INTO  high_payed_emp_id (emp_id)
 select * from
 (
 SELECT emp_id
 FROM cursor_table ORDER BY emp_salary DESC
  )
 WHERE ROWNUM <= 1;

Answer 4

在我看来，这是在Oracle中选择最高工资的最简单方法：

select emp_id from cursor_table where emp_salary 
= (select max(emp_salary) from cursor_table)