ENY interview Question | Divide Employees Into Teams Using Salary | CTE and DENSE_RANK Explained

[@parthchauhan9305]

Alternate approach with OVER clause: -
with cte as (
SELECT
*,
COUNT(name) OVER (partition by salary) as cnt
FROM company
)
select
dense_rank() OVER (order by salary) as team_id,
emp_id,name,salary
from cte where cnt = 2