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

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

Question Posted / naveen

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

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is pragma autonomous transaction in oracle?

1125

How to update values in a table in oracle?

1080

How to create a server parameter file?

1188

query optmization techniques and quwry analyser+projects+ppts

2469

How to view existing locks on the database?

1103

What is a nested table?

1112

What is ceil and floor in oracle?

1123

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2314

How to set up autotrace for a user account?

1113

How to commit the current transaction in oracle?

1188

How to select an oracle system id (sid)?

1123

What are the differences between interval year to month and interval day to second?

1068

What is the difference between primary key and unique key and foreign key in oracle?

1037

How to start a specific oracle instance?

1081

How to display row numbers with the records?

1139