题目描述
有一个薪水表salaries简况如下:
对所有员工的薪水按照salary进行按照1-N的排名,相同salary并列且按照emp_no升序排列:
答案详解
select a.emp_no,a.salary,count(distinct b.salary) from salaries a inner join salaries b on a.salary<=b.salary group by a.emp_no order by a.salary desc
select a.emp_no,a.salary,count(distinct b.salary) from salaries a inner join salaries b on a.salary<=b.salary group by a.emp_no order by a.salary desc