lidanhua的博客

select e.employee_id, e.first_name || ' ' || e.last_name name, e.department_id dept, e.hire_date, e.salary, rank() over(partition by e.department_id order by e.salar...

众数： select * from (select salary, repeat_num, dense_rank() over(order by repeat_num desc) rank_repeat_num from (select salary, count(*) repeat_num ...

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;