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

What are the characteristics of modern DBMS?

1033

How to rebuild master databse?

1032

What is a file group?

1020

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

950

Explain trigger and its types?

1014

If the job running very slow what is the action you do

1828

What are different types of replication in sql server?

1036

How can you start sql server in different modes?

925

How do I save a stored procedure in sql server?

932

Explain the flow of creating a cube? : sql server analysis services, ssas

1005

What gets stored inside msdb database?

1197

Define primary key?

1079

What is a collation in ms sql server?

1020

What are the character string functions supported by sql server 2005?

937

How to get a list of columns in a view using the "sp_help" stored procedure?

991