SELECT d.DEPARTMENT_NAME,max(e.salary) from HR.EMPLOYEES e join HR.DEPAR

i want department wise maxmum salary and empolyee name

Question Posted / kk

Answer Posted / kk

SELECT d.DEPARTMENT_NAME,max(e.salary) from HR.EMPLOYEES e
join HR.DEPARTMENTS d
on e.DEPARTMENT_ID=d.DEPARTMENT_ID
group by d.DEPARTMENT_NAME;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How can I create database in oracle?

996

Explain about your project and its relation to the current job position you are applying to?

991

What is null value in oracle?

1076

What is a package in oracle?

1081

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2109

How can windows applications connect to oracle servers?

1039

What is the difference between translate and replace?

1048

Explain a segment?

1073

State and explain the different types of data models?

925

How to drop a tablespace?

1028

How to define a specific record type?

1072

what is the difference between data migration and production migration.

2327

What is the usage of control file in oracle?

1072

How to create a new table in oracle?

1135

How a tablespace is related to data files?

1091