Find 2nd highest salary using CTE
Exercise
Correct!
code_here
(
SELECT Name,
Salary,
code_here AS 'SalaryRank'
FROM dbo.Employees
)
SELECT Name, Salary
FROM Salaries
WHERE SalaryRank = 2
WITH Salaries AS
(
SELECT Name,
Salary,
DENSE_RANK() OVER(ORDER BY Salary DESC) AS 'SalaryRank'
FROM dbo.Employees
)
SELECT Name, Salary
FROM Salaries
WHERE SalaryRank = 2
assert(line0 == l0); assert(line4 == l4);
function rpls(str){
return str.toLowerCase().replace(/'/g,'').replace(/ /g, '');
}
var l0 = rpls("WITH Salaries AS");
var l4 = rpls("DENSE_RANK() OVER(ORDER BY Salary DESC) AS 'SalaryRank'");