Interested to Buy Any Domain ? << Click Here >> for more details...
i want department wise maxmum salary and empolyee name
- 9 Answers
- 29647 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 |
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
what is the dual table in oracle?
What is translate in oracle?
Why does oracle 9i treat an empty string as null?
What is oracle rowcount?
What is oracle datasource?
What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)
3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.
What is a cluster?
How to use in conditions in oracle?
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
After update how do u know how many records got updated
Oracle General 
