select level,deptno,max(sal) from emp where level in (1,2) connect byy p

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

Question Posted / shreya

Answer Posted / shreya

select level,deptno,max(sal)
from emp
where level in (1,2)
connect byy prior sal>sal
group by level,deptno
order by deptno

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a primary key sql?

1032

what are the advantages of using stored procedures? : Sql dba

1091

How to look at the current sql*plus system settings?

1134

Does sql support programming?

1047

What is form and report?

960

What is pivot table in sql?

1081

what are the differences between char and varchar? : Sql dba

1057

What is trigger and stored procedure in sql?

1016

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1095

how would you get the current date in mysql? : Sql dba

952

What is the function that is used to transfer a pl/sql table log to a database table?

987

How to Execute a Package in PL/SQL.?

1183

What is pl sql and why it is used for?

1098

what is query cache in mysql? : Sql dba

1015

What is pl sql collection?

945