oracle中如何用sql实现查出某一张表中,某个字段的值最大的10条记录

2025-04-13 19:32:35
推荐回答(1个)
回答1:

以用户HR为例:
select rownum rn,t.*from (select employee_id,first_name,salary from employees order by salary) t where rownum <=10;