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

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

Please Help Members By Posting Answers For Below Questions

What privilege is needed for a user to query tables in another schema?

973

What is a cognitive schema?

973

Which are the five query types available in oracle?

950

How to start instance with a minimal initialization parameter file?

1045

How to view the data files in the current database?

1099

Difference between oracle's plus (+) notation and ansi join notation?

1108

Where is the export dump file located?

1159

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1865

How to use fetch statement in a loop?

1022

How do I find my oracle client driver version?

1043

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2827

Where are the settings stored for each instance in oracle?

1106

types of indexes and the rationale behind choosing a particular index for a situation.

2510

What is transport network substrate (tns) in oracle?

1047

How to check the server version in oracle?

1094