HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG
WITH DEPARTMENT NAMES? E.g EMP,DEPT
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
Can a formula column referred to columns in higher group ?
How do we switch from init.ora file to asp file?
How to convert numbers to characters in oracle?
which clause we are not used in where clause?
WHAT IS ecc 6.0
24. Display the order number for all orders whose average item cost is greater than the overall average item cost across all orders.
How to build data dictionary view an new database?
List out the types of joins.
What happens to the current transaction if the session is ended?
How to convert raw data type into text in oracle? Explain
what is kernel?
what is the difference between first normal form & second normal form?