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 index in Oracle?

1074

What are set operators?

1083

What are the limitations of check constraint?

1033

State any two functions of oracle?

1046

Explain the blob datatype?

1072

What is an oracle transaction?

1146

How to view all columns in an existing table?

936

What is data block in Oracle?

1116

Name the various constraints used in oracle?

1019

What is the difference between post-database commit and post-form commit?

1202

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2325

State and explain the different types of data models?

944

What is data type in oracle?

1125

What is Data Dictionary Cache in Oracle?

1165

What is a nested table?

1062