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

how to find the n'th highest salary from emp ?

Question Posted / bharath

Answer Posted / bharath

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to check the server version in oracle?

618

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

1959

How to start a new transaction in oracle?

597

What is blob datatype?

575

What is a relational database management system?

687

What is a schema in oracle?

555

Explain oracle left join with an example?

596

What do you mean by group by clause?

569

What is recovery manager(rman) backup in Oracle?

638

types of indexes and the rationale behind choosing a particular index for a situation.

1993

Â What are the oracle DML commands possible through an update strategy?

589

How to build data dictionary view an new database?

542

What is a sub query? Describe its types?

554

How to define default values for formal parameters?

605

How to execute a stored procedure in oracle?

626