SELECT LEVEL,MAX(SAL) FROM EMP WHERE LEVEL=&LEVEL CONNECT BY PRIOR SA

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

Question Posted / venki

Answer Posted / venki

SELECT LEVEL,MAX(SAL) FROM EMP WHERE LEVEL=&LEVEL
CONNECT BY PRIOR SAL>SAL GROUP BY LEVEL;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is ASM (Automatic Storage Management) in Oracle?

719

What are the four Oracle system processes that must always be up and running for the database to be useable?

597

How to rename a column in an existing table?

623

What is redo log?

632

What is oracle database 10g express edition?

608

How to use "in" parameter properly?

623

What is tns service name?

630

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

572

What is the recommended interval at which to run statspack snapshots, and why?

2442

How to rollback the current transaction in oracle?

548

What is the difference between Delete, Truncate and Drop in Oracle?

608

Can you have more than one content canvas view attached with a window ?

1820

How do you find current date and time in oracle?

596

Explain the use of Merge statement in oracle 11g

600

How can we force the database to use the user specified rollback segment?

562