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

Explain what are clusters?

1155

How can you merge two tables in oracle?

1046

How to define an anonymous procedure with variables?

1236

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

2544

What is the difference between substr and instr?

1088

What is ASM (Automatic Storage Management) in Oracle?

1241

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2336

What is key preserved table?

1078

What is the difference between postgresql and oracle?

1101

How to create a table interactively?

1161

Why use resource manager in Oracle?

1172

What is the data type of dual table?

1062

How to generate query output in html format?

1206

How to run create database statement again?

1216

How to estimate disk space needed for an export job?

1103