select min(sal) from tablename where sal in (select top n-1 sal from

What is the query to find nth highest salary?
What is the use of cursors?

Question Posted / tina

Answer Posted / tina

select min(sal)
from tablename
where sal in
(select top n-1 sal from tablename order by sal desc)

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What are the different types of transformation available in informatica.

1030

draw informatica architecture 8.6 ?

3822

What do you mean by enterprise data warehousing?

1002

How can you differentiate between powercenter and power map?

1019

What is target load order?

1190

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1035

what is the hint? how to use it to reduce the query processing in program?

7634

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2296

What are the different ways to implement parallel processing in informatica?

1342

What is the difference between Active and Passive transformation?

1085

How union transformation is used?

959

What are the tuning techniques you applied during your last project

1968

Please let me know how to make Data masking in informatica..

1665

What are the different lookup cache(s)?

1036

What is informatica metadata and where is it stored?

934