select * from emp e where &num=(select count(distinct(sal)) from emp

how to find nth highest salary

Question Posted / babu

Answer Posted / babu

select * from emp e where &num=(select count(distinct(sal))
from emp b where b.sal>=e.sal)

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain log shipping and mention its advantages.

988

Does a server store data?

861

List the various tools available for performance tuning?

842

How to filter out duplications in the returning rows in ms sql server?

1066

What is change data capture (cdc) feature?

997

Is BCNF better than 2NF & 3NF? Why?

1002

Can you explain different types of locks in sql server?

910

What is difference between equi join and inner join?

856

What are sql server functions?

935

What is sql server replication? : sql server replication

921

What types of replication are supported in sql server?

996

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

930

What is the main difference between ‘between’ and ‘in’ condition operators?

1102

what is difference between NULL and ISNULL in SQL Server 2008?

964

What is partitioned view?

850