select salary from tablename t1 where n=(select count(*)from tablename t2

how to find nth highest salary

Question Posted / elumalai.k

Answer Posted / elumalai.k

select salary from tablename t1
where n=(select count(*)from tablename t2
where t1.salary<=t2.salary)

Is This Answer Correct ?

16 Yes

16 No

Please Help Members By Posting Answers For Below Questions

How to view existing indexes on an given table using sp_help?

1208

Difference between group by clause and having clause in SQL?

1029

How to use values from other tables in update statements in ms sql server?

1188

What is difference between count (*) and count 1?

978

What is the difference between delete and truncate statements?

1131

How to count rows with the count(*) function in ms sql server?

1062

What is sql view?

1118

can we have a nested transaction? : Sql server database administration

1195

Explain the creation and execution of a user-defined function in the sql server?

1113

what is the sql equivaent of the dataset relation object ?

2070

role of sql sever 2005 in database rather than any other database

1992

How to provide default values to stored procedure parameters?

1105

How to trouble shoot if unable to connect SQL Server

2033

Can we install sql server 2016 on windows 7?

1200

What is check constraint in sql server?

1052