select max(sal) from emp having max(sal)!=(select max(sal) from emp where

a query to select maxmun 3 salaries of employee table

Question Posted / neo devan

Answer Posted / neo devan

select max(sal) from emp having max(sal)!=(select max(sal)
from emp where max(sal)!=(select max(sal) from emp));

Is This Answer Correct ?

0 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is oracle analytical function?

1228

Give the various exception types.

1036

In which language oracle has been developed?

1134

Can select statements be used on views in oracle?

1082

What is the oracle implicit cursor?

1111

Explain what are clusters?

1155

How to convert character types to numeric types?

1192

How to create a stored procedure in oracle?

1150

What happens to the indexes if a table is recovered?

1045

What is oracle and what are its different editions?

1118

What privilege is needed for a user to insert rows to tables in another schema?

1056

Can we use bind variables in oracle stored procedure?

986

How can I create database in oracle?

1066

How to create a table interactively?

1163

What is ceil and floor in oracle?

1119