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 are oracle functions?

1028

How can you use check constraints for self referential integrity?

964

Can multiple columns be used in group by in oracle?

981

How to recover a dropped table in oracle?

1036

Why we use bulk collect in oracle?

1035

How to change program global area (pga) in oracle?

1084

How to use subqueries with the in operator using oracle?

1089

Name the three major set of files on disk that compose a database in Oracle?

1119

How to write a query with an inner join in oracle?

1034

What is the purpose of save points in oracle database?

1104

Can select statements be used on views in oracle?

1022

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2263

What is the difference between hot backup and cold backup in oracle?

1008

How to connect to a local oracle 10g xe server?

992

How would you go about verifying the network name that the local_listener is currently using?

2043