i want department wise maxmum salary and empolyee name
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Answer / sanjaya
select distinct deptno, max(sal)over ( partition by deptno order by deptno) from emp;
Is This Answer Correct ? | 1 Yes | 1 No |
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 |
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 |
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 |
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 |
Answer / shiva
select deptno,ename,max(sal)
from emp
group by deptno,ename;
Is This Answer Correct ? | 0 Yes | 7 No |
How to rename an index?
Why does oracle 9i treat an empty string as null?
What is oracle server autotrace in oracle?
How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column?
How to experiment a data lock in oracle?
What are the Referential actions supported by FOREIGN KEY integrity constraint ?
What suggestions do you have to reduce the network traffic?
What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
Why oracle is used?
What is an Oracle sequence?
Is oracle a programming language?
What is a lookup table in oracle?