In this article I am going to explain how you can find nth highest salary of the employee in SQL Server.

It is very common question asked by interviewer that how to find 2nd highest salary of employee or how to find 3rd highest salary of employee or how to find nth highest salary of employee in SQL Server. Here in this Sql Server Query Example i will Show you how to find 2nd,3rd,4th,.......,nth highest salary of employee. 

For this sql server query example i have created a Temporary Sql server Table in Sql Server Database named #EmpDetails .And enterd some values to this sql server table.The script is given below.

CREATE TABLE #EmpDetails(EMPID
int,EMPNAME NVARCHAR(10),EMPSAL int)
INSERT INTO #EmpDetails VALUES
(1,'RAJ',2000)
INSERT INTO #EmpDetails VALUES(2,'SURESH',12000)
INSERT INTO #EmpDetails VALUES(3,'SURAJ',15000)
INSERT INTO #EmpDetails VALUES(4,'SUNEEL',14000)
INSERT INTO #EmpDetails VALUES(5,'SANJEEV',13000)
INSERT INTO #EmpDetails VALUES(6,'ATUL',12070)
INSERT INTO #EmpDetails VALUES(7,'VINEET',12600)
INSERT INTO #EmpDetails VALUES(8,'VIVEK',12700)

Now Check the table for values.

 select * from #EmpDetails

 It will display The following Rows.

EMPID	EMPNAME	EMPSAL
1	RAJ	2000
2	SURESH	12000
3	SURAJ	15000
4	SUNEEL	14000
5	SANJEEV	13000
6	ATUL	12070
7	VINEET	12600
8	VIVEK	12700

Once table creation is completed now we will see different ways to get 2nd, 3rd, etc or nth highest salary of employee. The below sql query can be used to get 1st, 2nd, 3rd, 4th, 5th ….etc highest salary of employee.

SELECT TOP 1 EMPSAL
FROM (
SELECT DISTINCT TOP n EMPSAL
FROM
#EmpDetails
ORDER BY EMPSAL DESC) a
ORDER BY EMPSAL

Replace n with 2 to find the second (2nd) highest salary of employee query will look like this .

SELECT TOP 1 EMPSAL
FROM (
SELECT DISTINCT TOP 2 EMPSAL
FROM
#EmpDetails
ORDER BY EMPSAL DESC) a
ORDER BY EMPSAL

Result will be
EMPSAL
----------
 14000

Replace n with 3 to find the third (3rd) highest salary of employee query will look like this .

SELECT TOP 1 EMPSAL
FROM (
SELECT DISTINCT TOP 3 EMPSAL
FROM
#EmpDetails
ORDER BY EMPSAL DESC) a
ORDER BY EMPSAL

Result will be
EMPSAL
 -------------
13000  

This topic is about sql server Comma Separated Values(csv) from Table Column.

There are Many times where we need to convert a set of rows in a single column to a comma separated (CSV) string , in this article i am going to tell you how you can get csv values from sql server table column.

For this sql server query example i have created a Temporary Table in Sql Server Database.

CREATE TABLE #MyTable(Column1 NVARCHAR(10))

INSERT INTO #MyTable VALUES('sdf')

INSERT INTO #MyTable VALUES('dfg')

INSERT INTO #MyTable VALUES('ghj')

INSERT INTO #MyTable VALUES('rty')

INSERT INTO #MyTable VALUES('hjk')

Here is a  SQL Query to find the list of Functions in SQL Server database.When you run this query it will show the list of all functions in SQL Server DataBase.

O_Id	Date	Price	Customer_Name
1	2012/11/12	10000	Rajesh
2	2012/10/23	16000	Shiv
3	2012/09/02	7000	rupa
4	2012/09/03	3000	Hansen
5	2012/08/30	20000	Jensen
6	2012/10/04	1000	Shiv