HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT

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

HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG
WITH DEPARTMENT NAMES? E.g EMP,DEPT

Question Posted / naveen

5 Answers
10887 Views
College School Exams Tests, DELL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT..

Answer / naveen

SELECT D.DEPTNO,D.DNAME,MAX(SAL) FROM EMP E,DEPT D WHERE
D.DEPTNO=E.DEPTNO GROUP BY D.DEPTNO,D.DNAME;

Is This Answer Correct ?

17 Yes

1 No

HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT..

Answer / rajiv

select dept.dname,max(sal) totalsal from emp,dept where dept.deptno=emp.deptno group by dept.dname;

Is This Answer Correct ?

2 Yes

0 No

HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT..

Answer / harika

select dname,max(sal) from emp e,dept d
where d.deptno=e.deptno
group by d.deptno;

Is This Answer Correct ?

3 Yes

6 No

HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT..

Answer / selvaraj v

In oracle 10g :

SELECT * FROM
(SELECT DEPTNO,
EMPNO,
ENAME,
SAL,
DENSE_RANK() OVER(PARTITION BY DEPTNO ORDER BY SAL
DESC) RANK
FROM EMP);

OUTPUT :
------------>

DEPTNO EMPNO ENAME SAL RANK
---------- ---------- ---------- ---------- ----------
10 7839 KING 5000 1
10 7782 CLARK 2450 2
10 7934 MILLER 1300 3
20 7788 SCOTT 3000 1
20 7902 FORD 3000 1
20 7566 JONES 2975 2
20 7876 ADAMS 1100 3
20 7369 SMITH 800 4
30 7698 BLAKE 2850 1
30 7499 ALLEN 1600 2
30 7844 TURNER 1500 3

DEPTNO EMPNO ENAME SAL RANK
---------- ---------- ---------- ---------- ----------
30 7521 WARD 1250 4
30 7521 WARD 1250 4
30 7654 MARTIN 1250 4
30 7900 JAMES 950 5

15 rows selected.

Is This Answer Correct ?

0 Yes

4 No

HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT..

Answer / guest

select *from emp where max(sal)=dept;

Is This Answer Correct ?

2 Yes

16 No

Post New Answer