I have one table :EID,Depid,ename,sal I want to have max(sal) in each departme

Categories >> Software >> Databases >> Oracle >> Oracle General
Suggest New Category

I have one table :EID,Depid,ename,sal
I want to have max(sal) in each department.

Question Posted / testingcareer.kpc

5 Answers
7938 Views
Microsoft, Oracle, TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I have one table :EID,Depid,ename,sal I want to have max(sal) in each department...

Answer / sunil

select depid,max(sal) from <table name> group by depid;

Is This Answer Correct ?

33 Yes

4 No

I have one table :EID,Depid,ename,sal I want to have max(sal) in each department...

Answer / omar

select e.department_id,max(e.salary)
from employees e
group by e.department_id
order by e.department_id desc;

Is This Answer Correct ?

2 Yes

0 No

I have one table :EID,Depid,ename,sal I want to have max(sal) in each department...

Answer / vengalrao

Dear Friends,

Depends upon table u can pick one max value is possible,one
table u cannot pick max value of all columans , then u can
refer one any ne column

select depid,max(sal) from <table name> group by depid;

Is This Answer Correct ?

2 Yes

1 No

I have one table :EID,Depid,ename,sal I want to have max(sal) in each department...

Answer / narasimha

select e.eid,e.sal,e.depid,e.ename,e.sal from emp e
where 1>(select count(*) from emp w where e.sal<w.sal and
e.depid=w.depid) order by e.deptno asc

Is This Answer Correct ?

0 Yes

3 No

I have one table :EID,Depid,ename,sal I want to have max(sal) in each department...

Answer / venkat

select * from emp_test where sal IN(select max(sal) from
emp_test group by deptno)

Is This Answer Correct ?

1 Yes

6 No

Post New Answer