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

definition of cluster and non-clustered index?

3008

How to select an oracle system id (sid)?

1044

What is a directory object?

1068

What is a parameter file in oracle?

1108

What is a initialization parameter file in oracle?

1018

what's query optimization and without use of IN AND Exist can we get another way data from query

2115

Explain oracle’s server parameter file.

971

What is dual table oracle?

964

how to join query for one source type is oracle another source type is sql server ?

2406

what is the difference between data migration and production migration.

2326

How to delete a column in an existing table?

1055

What is a snapshot in oracle database?

1001

What is literal?

981

What is the difference between Delete, Truncate and Drop in Oracle?

1104

Difference between inner join vs where ?

1007