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

What are functions in sql?

936

Why do we create views in sql?

1130

Is vs as in pl sql?

968

Is pl sql a scripting language?

1013

What is the usage of when clause in trigger?

1032

What are sql functions? Describe the different types of sql functions?

1122

What are the types of operators available in sql?

1050

What is the difference between microsoft access and sql server?

1033

What is sql query optimization?

1090

What are the uses of sysdate and user keywords?

1086

Is join an inner join?

948

What are sql triggers used for?

980

What is the difference between view and stored procedure?

950

Can we enter data in a table in design view?

952

What do you mean by field in sql?

1069