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

How to connect to oracle using service name instead of sid?

1068

How do we represent comments in oracle?

1097

How do I uninstall oracle client from windows?

1058

Is it possible to split the print reviewer into more than one region ?

2339

What do database buffers contain?

1083

What is object data modeling?

1017

Difference between varchar and varchar2 data types?

1262

How to open a cursor variable?

1089

How do we create privileges in oracle?

1100

1) Does oracle have any table which contain all the exceptions and it's code internally?

1803

How to pass parameters to procedures?

1089

What is a trigger oracle?

1137

Can we convert a date to char in oracle and if so, what would be the syntax?

1063

What is execute immediate in oracle?

1078

What is Segment Advisor in Oracle?

1146