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

What is Segment Advisor in Oracle?

1145

How does oracle handle read consistency?

1151

Describe the types of sub query?

1057

How do we get field detail of a table?

1125

Explain enable novalidate constraint.

1131

How to convert character types to numeric types?

1191

What happens if variable names collide with table/column names?

1263

How a tablespace is related to data files?

1162

List the types of joins used in writing subqueries?

1037

How to write text literals in oracle?

1118

Can we create trigger on materialized view in oracle?

1041

What is the use of aggregate functions in oracle?

1071

What is a cognitive schema?

1033

How many types of auditing in Oracle?

1086

How to rename a tablespace in oracle?

1124