select * from emp e1 where &n=(select count(distinct (e2.sal) from emp

how to find nth highest salary

Question Posted / satesh naidu

Answer Posted / satesh naidu

select * from emp e1 where &n=(select count(distinct
(e2.sal) from emp e2 where e.sal>e1.sal)

Hai friends try this.u will get nth highest salary.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to create sub reports?

242

What are sql server procedures?

981

What is the difference between a function and a trigger?

1082

Explain differences between web edition and business edition?

119

What is merge?

1019

Explain what is public role in sql server?

1135

What happens if the update subquery returns multiple rows in ms sql server?

1125

Explain the difference between function and stored procedure?

942

What is data source view or dsv? : sql server analysis services, ssas

1000

Can you please differentiate between a primary key and a unique key?

1009

What is table valued function and scalar valued functions?

1089

Can we join two tables without primary key?

1054

Do you know concepts and capabilities of sql server?

1060

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

885

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1135