SQL每日一题(20220325)
with tt2 as (
select a.*,b.Name ,dense_rank() over(partition by b.name order by a.Salary desc) rk from t0917 a left join t0917b b on a.DepartmentID=b.id
)
select * from tt2 where rk<=3;
SQL每日一题(20220325)
with tt2 as (
select a.*,b.Name ,dense_rank() over(partition by b.name order by a.Salary desc) rk from t0917 a left join t0917b b on a.DepartmentID=b.id
)
select * from tt2 where rk<=3;