SELECT ENAME ,SAL ,DEPTNO FROM EMP WHERE SAL IN (SELECT MAX(SAL) FROM E

i want department wise maxmum salary and empolyee name

Question Posted / jaber badarneh

Answer Posted / jaber badarneh

SELECT ENAME ,SAL ,DEPTNO
FROM EMP
WHERE SAL IN (SELECT MAX(SAL) FROM EMP GROUP BY DEPTNO)

Is This Answer Correct ?

19 Yes

19 No

Please Help Members By Posting Answers For Below Questions

Is oracle a programming language?

998

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2271

What are the ways tablespaces can be managed and how do they differ?

2378

How to connect asp pages to oracle servers?

1078

How to run create database statement?

1040

What are the built-in functions used for sending Parameters to forms ?

3392

What is the difference between formal parameters and actual parameters?

1095

Explain the use of Merge statement in oracle 11g

1030

What is the dynamic sql in oracle?

1083

How do I find my oracle client driver version?

1048

How to convert times to characters in oracle?

1028

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1031

Explain integrity constraints?

1110

please explain.. DB architecture ...

2030

How to return top 5 rows in oracle?

1071