select * from (
select e.employee_id,e.first_name,e.salary,row_number() over(order by e.salary) rank,count(*) over() total from emp e) where rank <=3 or rank >=total-2;
Oracle SQL前三行,后三行
最新推荐文章于 2024-07-31 17:06:19 发布
select * from (
select e.employee_id,e.first_name,e.salary,row_number() over(order by e.salary) rank,count(*) over() total from emp e) where rank <=3 or rank >=total-2;