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

How to loop through data rows in the implicit cursor?

1047

What are the parameters that we can pass through a stored procedure?

1045

What is a read write transaction in oracle?

1063

What is merge statement used for?

1001

How to update values in a table in oracle?

997

Can we store images in oracle database?

986

how to do daily transactions with out sql* loader control file regesterd in apps?

1663

How to start instance with a minimal initialization parameter file?

1022

Explain the use of Merge statement in oracle 11g

1010

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

998

How to change program global area (pga) in oracle?

1069

What are the differences between date and timestamp in oracle?

1028

How to concatenate two text values in oracle?

1095

What is oracle and what are its different editions?

1054

what are bitmap indexes? How does they work?

2217