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

What is sql query optimization?

1193

Is not equal in sql?

1063

What is difference between pls_integer and integer?

1011

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1116

Can variables be used in sql statements?

1074

What are the different types of tables in sql?

1067

Which is faster truncate or drop?

1101

How many sql core licenses do I need?

995

What are operators available in sql?

1095

What is meant by temporal data?

1003

What is the use of function "module procedure" in pl/sql?

1237

How to know the last executed procedure?

1156

What are the advantages of normalization?

1129

What are the different operators available in sql?

1058

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1273