Login
Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Write A Query To Get Nth Highest Salary

Rakesh Pattanayak
11 Jan 0 0
WITH 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.
0 Dislike
Follow 2

Please Enter a comment

Submit

Other Lessons for You

MS-SQL Database
1. Select: 01-Select All Given a City table, whose fields are described as: +-------------+----------+ | Field | Type | +-------------+----------+ | ID | int(11) | | Name ...

Prashant Kumar | 27 Feb

0 0
0
What Is WorkTable In SQL Server?
What is WorkTable in SQL Server? USE AdventureWorks2014 GO SET STATISTICS IO ON GO SELECT * FROM Production.Product p CROSS JOIN Production.Product p1 GO If you run above query,...

Amitava Majumder | 19/12/2017

0 0
0
What Is Power Query?
Power Query is an Excel add-in that can be used for data discovery, reshaping the data and combining data coming from different sources. Power Query is one of the Excel add-ins provided as part of Microsoft...
PowerPivot For Excel
PowerPivot is an add-in for Microsoft Excel 2010 that enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous...
What Are Macros?
i. Macros are little programs that run within Excel and help automate common repetitive tasks. Macros are one of Excel's most powerful, yet underutilized feature. Using macros, you can save hours and boost...

Looking for MS SQL Training?

Find best MS SQL Training in your locality on UrbanPro.

Do you offer MS SQL Training?

Create Free Profile »
Sponsored

Find Best MS SQL Training?

Find Now »