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 drop a tablespace?
I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
what is difference between table and view? where to use views? thanks in advance!
Explain overloading. Can functions be overloaded?
State the difference between a primary key and foreign key?
What is a private synonym?
How to handle a single quote in oracle sql?
Explain a segment?
How to apply filtering criteria at group level in oracle?
How to define a specific record type?