select deptno, max(sal) from (select * from emp order by sal desc) where

i need department wise top 2 employees salary.which logic
i will use

Question Posted / ramya p

Answer Posted / ramya p

select deptno, max(sal) from (select * from emp order by
sal desc)
where rownum < 3
group by deptno
order by max(sal) desc;

Is This Answer Correct ?

5 Yes

12 No

Please Help Members By Posting Answers For Below Questions

How can a pl sql block be executed?

949

What are the different dcl commands in sql?

1180

What are different types of sql commands?

1122

which operator is used in query for pattern matching? : Sql dba

1010

Is sql a oracle?

984

How does sql store data?

925

How many commands are there in sql?

1036

Is keyword pl sql?

1012

how to get a list of indexes of an existing table? : Sql dba

960

What does trigger mean in slang?

1070

Why are aggregate functions called so?

952

How many rows can sqlite handle?

1121

what is data control language? : Sql dba

1030

What is schema in sql example?

1186

Does sql support programming?

1076