select deptno,sal from (select deptno,sal,row

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

Question Posted / vikas kapoor

Answer Posted / vikas kapoor

select deptno,sal from
(select deptno,sal,row_number() over(partition by deptno orderby sal) r from emp ) where r<3

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

explain primary keys and auto increment fields in mysql : sql dba

949

Does truncate need commit?

924

What is the purpose of a sql?

962

How to run sql commands in sql*plus?

1157

Can we use commit inside a trigger?

1071

What is sql procedures and functions?

992

what are the advantages a stored procedure? : Sql dba

962

Can you call pl/sql package functions from within a fast formula?

1021

what are aggregate and scalar functions? : Sql dba

1041

In pl/sql, what is bulk binding, and when/how would it help performance?

982

Explain the components of sql?

1043

What is the advantage of nosql?

1043

Explain character-manipulation functions?

1103

Is sql procedural language?

953

difference between anonymous blocks and sub-programs.

1120