Thanks for the input :).
I guess the answer is
;WITH CTE AS
SELECT Salary, rnk=DENSE_RANK() OVER (ORDER BY Salary DESC) FROM Employee
SELECT DISTINCT Salary FROM CTE...
Thought this forum was about SQL Server Q&A. Don't know why the replies are so "pedagogical". Anywise, I am just a learner who wanted to hear it...
Excuse me, school teacher. The question is for SQL Server experts.
Hi SQL Server Experts,
I want to get the nth highest salary without using TOP and sub-query from the following table.
Separate names with a comma.