Select level,Max(sal) from emp Where level=&level connect by prio

How to retrieve 5th highest sal from emp table?

Question Posted / venubabu

Answer Posted / venubabu

Select level,Max(sal) from emp
Where level=&level connect by prior sal>sal
group by level;

sql>Enter value for level:5

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is hash cluster in oracle?

694

What are the restrictions on external table columns?

624

What is Java Pool in Oracle?

702

What is a trigger and what are its types?

689

How to get execution statistics reports on query statements?

674

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1757

Is the After report trigger fired if the report execution fails ?

2517

What is difference between truncate and delete?

634

How to call a stored function with parameters?

641

What are the general rules on data consistency?

662

How to get maxsal , minsal, ename department wise in single query

1134

How to rename a column in an existing table?

683

Please explain drop constraint oracle?

701

Can select statements be used on views in oracle?

672

Describe an oracle table?

661