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

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

Question Posted / venky

Answer Posted / venky

select * from emp e where &n=(select count(distinct(b.sal))
from emp b where e.sal=b.sal);

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Scheduling properties,whats the default (sequential)

1456

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1616

Enlist the tasks for which source qualifier transformation is used.

582

Describe the impact of several join conditions and join order in a joiner transformation?

639

What is the use of transformation?

567

What is rank transform?

595

What is a repository? And how to add it in an informatica client?

642

How to use pmcmd utility command?

576

what are the deliverables?in your project?

1648

How does a sorter cache works?

563

What is update strategy transform?

563

where to store informatica rejected data?

672

How can we delete duplicate rows from flat files?

736

What is the Rank index port in Rank transformation?

666

What are some examples of informatica etl programs?

529