Interested to Buy Any Domain ? << Click Here >> for more details...
i want department wise maxmum salary and empolyee name
- 9 Answers
- 29354 Views
- I also Faced
- E-Mail Answers
Answer Posted / ajaikumar
Select e.ename, d.deptname, e.sal
from emp e, dept d
where
e.deptno = d.deptno
and
e.sal IN (
select max(sal) from emp
group by deptno
)
| Is This Answer Correct ? | 6 Yes | 5 No |
Post New Answer View All Answers
How would you change old and new values in an insert, delete and update triggers?
How do you tell what your machine name is and what is its IP address?
How to omit columns with default values in insert statement in oracle?
Describe varray?
Why do we use bulk collect in oracle?
List out the types of joins.
Explain an integrity constrains?
What is transaction control statement and how many types of transaction control statement in Oracle?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
How many anonymous blocks can be defined?
can u plz provide me oca sql dumps please i need them
What is a directory object?
State some uses of redo log files?
What are the ansi data types supported in oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
