i want department wise maxmum salary and empolyee name

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

Question Posted / ramesh

9 Answers
27255 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

i want department wise maxmum salary and empolyee name..

Answer / sanjay pradhan

select ename,sal,deptno from emp where (deptno,sal) in
(select deptno,max(sal) from emp group by deptno);

Is This Answer Correct ?

15 Yes

4 No

i want department wise maxmum salary and empolyee name..

Answer / ajaikumar

Select e.ename, d.deptname, e.sal
from emp e, dept d
where
e.deptno = d.deptno
and
e.sal IN (
select max(sal) from emp
group by deptno
)

Is This Answer Correct ?

6 Yes

5 No

i want department wise maxmum salary and empolyee name..

Answer / jaber badarneh

SELECT ENAME ,SAL ,DEPTNO
FROM EMP
WHERE SAL IN (SELECT MAX(SAL) FROM EMP GROUP BY DEPTNO)

Is This Answer Correct ?

19 Yes

19 No

i want department wise maxmum salary and empolyee name..

Answer / sanjaya

select distinct deptno, max(sal)over ( partition by deptno order by deptno) from emp;

Is This Answer Correct ?

1 Yes

1 No

i want department wise maxmum salary and empolyee name..

Answer / sai krishna

Select * from (Select Dense_Rank() over ( Partition by department_id Order by salary desc) as Rnk,E.* from HR.Employees E) where Rnk=1;

Is This Answer Correct ?

0 Yes

0 No

i want department wise maxmum salary and empolyee name..

Answer / kk

SELECT d.DEPARTMENT_NAME,max(e.salary) from HR.EMPLOYEES e
join HR.DEPARTMENTS d
on e.DEPARTMENT_ID=d.DEPARTMENT_ID
group by d.DEPARTMENT_NAME;

Is This Answer Correct ?

0 Yes

0 No

i want department wise maxmum salary and empolyee name..

Answer / abhisudipta

select d.dept_name,e.emp_nm,max(e.sal) as salary
from dept d, emp e
where d.dept_no=e.dept_no and e.emp_nm = (select emp_nm from
emp where sal=(select max(sal) from emp where
dept_no=d.dept_no))
group by d.dept_name,e.emp_nm;

Is This Answer Correct ?

6 Yes

7 No

i want department wise maxmum salary and empolyee name..

Answer / satya

select empno,max(sal) sal,deptno from emp where empno in
(select e.empno from emp e where e.sal=(select max(a.sal) from
emp a where deptno=e.deptno)) group by deptno,empno;

Is This Answer Correct ?

2 Yes

3 No

i want department wise maxmum salary and empolyee name..

Answer / shiva

select deptno,ename,max(sal)
from emp
group by deptno,ename;

Is This Answer Correct ?

0 Yes

7 No

Post New Answer