Interested to Buy Any Domain ? << Click Here >> for more details...
HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG
WITH DEPARTMENT NAMES? E.g EMP,DEPT
- 5 Answers
- 10640 Views
- College School Exams Tests, DELL, I also Faced
- E-Mail Answers
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 |
Explain joins in oracle?
Which is better Oracle or MS SQL? Why?
how to retrieve data from different tables ,place this data in different excel worksheets.
How to change program global area (pga) in oracle?
How can I combine multiple rows into a comma-delimited list in oracle?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
What is literal?
When do I need to use a semicolon vs a slash in oracle sql?
How to assign query results to variables?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is COST-based approach to optimization ?
How to export your own schema?
Oracle General 
