select salary from table t where n-1=(select distinct count (sal) from tab

how to find nth highest salary

Question Posted / affu

Answer Posted / affu

select salary from table t where n-1=(select distinct count
(sal) from table t1 where t1.sal>t.sal)

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain different types of index?

1106

What is a non-clustered index?

1046

What happens when the SQL Azure database reaches Max Size?

113

What are the different types of stored procedures?

1156

How to fine-tune reports?

279

How to convert a numeric expression from one data type to another?

1096

Explain transaction isolation levels in sql server?

1185

What are the advantages dts has over bcp?

1051

How to search for a string in all stored procedure in sql server?

1056

How many replicas are maintained for each sql azure db?

124

What is candidate key with example?

1034

What is a performance monitor?

1024

What are the advantages of using third-party tools?

1037

What are diverse clauses that form a part of sql?

1113

Which tools are available to manage SQL Azure databases and servers?

115