Interested to Buy Any Domain ? << Click Here >> for more details...
i want department wise maxmum salary and empolyee name
- 9 Answers
- 29361 Views
- I also Faced
- E-Mail Answers
Answer Posted / satya
select empno,max(sal) sal,deptno from emp where empno in
(select e.empno from emp e where e.sal=(select max(a.sal) from
emp a where deptno=e.deptno)) group by deptno,empno;
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
How to write a query with a right outer join in oracle?
What is raw datatype?
How do we represent comments in oracle?
What are set operators?
What is a procedure in oracle?
Explain the use of record length option in exp command.
Explain constraining triggers.
What is rich query?
What is data block in Oracle?
Can select statements be used on views in oracle?
How to create a new view in oracle?
How to create a new user account in oracle?
How to list all indexes in your schema?
How to write an inner join with the where clause in oracle?
Explain view?
