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

how to find nth highest salary

Question Posted / debasish

Answer Posted / debasish

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

Is This Answer Correct ?

19 Yes

11 No

Please Help Members By Posting Answers For Below Questions

What are cursors and when they are useful?

1011

How many tables can be joined in SQL Server?

1003

What are the types of database recovery models?

1054

Explain Reporting Life Cycle?

111

Why main is user defined function?

945

Does a specific recovery model need to be used for a replicated database? : sql server replication

911

Can two tables share a primary key?

949

What are the new features are introduced in sql server 2012 reporting services?

143

What is blocking?

977

What is a livelock?

911

What happens when the SQL Azure database reaches Max Size?

107

How to convert numeric values to integers in ms sql server?

1004

Explain features of analysis services?

922

List out a number of the wants to setup a SQL Server failover cluster?

1006

you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

892