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

How to change system global area (sga) in oracle?

992

What is a table index?

1071

How to use fetch statement in a loop?

1006

What happens in oracle commit?

1002

How to call a stored function in oracle?

1008

What are the roles of dba?

1054

Explain the use of analyse option in exp command.

1110

How to grant create session privilege to a user in oracle?

975

What are set operators?

1061

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1847

20. Using a set operator, display the client number of all clients who have never placed an order.

2169

Can you have more than one content canvas view attached with a window ?

2313

What is the data pump export utility?

1061

What is a package in oracle?

1080

Which are the five query types available in oracle?

934