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

Can we use bind variables in oracle stored procedure?

917

How to view all columns in an existing table?

896

how to handle exceptions in post production

1378

How to get a list of all background sessions in the database?

958

Is oracle a relational database?

888

How to insert multiple rows with one insert statement in oracle?

1041

Explain oracle left join with an example?

964

what is the scripts in data base?

2099

Is java required for oracle client?

941

State the various uses of dbcc command?

1011

How to call a sub procedure?

1050

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2282

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

977

Where is the export dump file located?

1101

What is the difference between truncate & delete command?

1147