select deptno,ename,max(sal) from emp group by deptno,ename;

i want department wise maxmum salary and empolyee name

Question Posted / shiva

Answer Posted / shiva

select deptno,ename,max(sal)
from emp
group by deptno,ename;

Is This Answer Correct ?

0 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What is a database schema in oracle?

1113

Explain the importance of .pll extension in oracle?

1013

Why do we need integrity constraints in a database?

1027

Briefly explain what is literal? Give an example where it can be used?

1045

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?

2829

How can we delete duplicate rows in a table?

978

What is the sid in oracle?

972

What are data pump export and import modes?

1072

What is concurrency in oracle?

1011

Explain parameter file in oracle.

1035

What is a read write transaction in oracle?

1094

Explain what are the different type of segments?

969

How to list all user accounts in oracle?

1031

What is a tns file?

1001

How can you use check constraints for self referential integrity?

971