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 the difference between union and union all command?

1009

What is sqlca in powerbuilder?

956

Can we use loop in sql?

924

Explain what is sql?

1061

What is keys and its types?

1022

How many types of cursors are available in pl/sql?

1045

what is cursor. write example of it. What are the attributes of cursor.

1312

how to create a test table in your mysql server? : Sql dba

946

What is exception? What are the types of exceptions?

1035

What is a subquery in sql?

977

What is the plv (pl/vision) package offers?

981

Explain what is an index?

1001

Is natural join same as inner join?

872

Is left join inner or outer by default?

975

What is sql table?

904