Learn MS SQL from the Best Tutors
Affordable fees 1-1 or Group class Flexible Timings Verified Tutors 
0WITH CTE AS
(
SELECT EmpID, EmpName, EmpSalary,
RN = ROW_NUMBER() OVER (ORDER BY EmpSalary DESC)
FROM dbo.Salary
)
SELECT EmpID, EmpName, EmpSalary
FROM CTE
WHERE RN = @NthRow
Use of CTE recomended as it helps in performance of the query.
Learn from Best Tutors on UrbanPro.
Are you a Tutor or Training Institute?
Join UrbanPro Today to find students near youThe best tutors for MS SQL Classes are on UrbanPro
The best Tutors for MS SQL Classes are on UrbanPro
