Interested to Buy Any Domain ? << Click Here >> for more details...
i want department wise maxmum salary and empolyee name
- 9 Answers
- 30122 Views
- I also Faced
- E-Mail Answers
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 |
What is a lookup table in oracle?
without using count(*) and rownum how can we count total record in a table
what is load balancing and what u have used to do this?(sql loader)
You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?
Explain self joins in oracle?
two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
what is RAID technology?which is better RAID 0+1 OR RAID 5?
How to call a sub procedure?
what is the difference between functional dependecy and multilevel dependency?
What is hash cluster in oracle?
What is an Oracle index?
Oracle General 
