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

How to provide login information for a new odbc dsn?

1099

How to use clusters?

1019

What is the full meaning of dml?

1001

How to find the list of fixed hard drive and free space on server?

1282

Differentiate between a primary key and a unique key.

1120

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1112

What is difference between equi join and inner join?

1041

What is function of ROLLUP ?

1144

What is the difference between stored procedure and functions?

1200

What are the different type of replication in sql server?

1017

List the various tools available for performance tuning?

927

What does it mean to normalize a database and why would you do it?

1024

What is Dependency Injection and provide example?

1182

Can you please explain the difference between primary keys and foreign keys?

1171

Write query to return all rows sql?

1112