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 a tablespace is related to data files?

1062

How to rollback the current transaction in oracle?

986

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1034

What is oracle thin client?

974

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

1986

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2247

How to execute a stored procedure in oracle?

1031

What happens to the indexes if a table is recovered?

944

Explain the use of online redo log files in oracle.

993

What privilege is needed for a user to create indexes in oracle?

965

What is MTTR advisor in Oracle?

1035

what are the default admin accounts in Oracle 10g ?

919

What is the data type of dual table?

920

How to execute a stored program unit?

1005

what are bitmap indexes? How does they work?

2184