select distinct(sal) from emp a where 3 = (select count(distinct(sal)) fro

how to find nth highest salary

Question Posted / bharath

Answer Posted / bharath

select distinct(sal) from emp a where 3 = (select
count(distinct(sal)) from emp b where a.sal<= b.sal)

replace 3 by 2 for second highest...

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to create a view with data from multiple tables?

961

What is the report builder?

131

Why use “nolock” in sql server?

979

What are synonyms?

910

can you instantiate a com object by using t-sql? : Sql server database administration

960

What are different types of raid levels?

1067

What do you understand by recursive stored procedures?

937

How to fine-tune reports?

247

What is de-normalization in sql database administration? Give examples?

926

Explain the microsoft sql server delete command?

948

Explain the purpose of indexes?

893

What is bit data type?

977

What do I need to start working with sql studio? : sql server management studio

1047

What is checkpoint in sql server?

1056

Does table partitioning improve performance?

899