Interested to Buy Any Domain ? << Click Here >> for more details...
i want department wise maxmum salary and empolyee name
- 9 Answers
- 30123 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
What is the difference between post-database commit and post-form commit?
What is a sub query and what are the different types of subqueries?
What is oracle used for?
Explain the use of rows option in imp command.
What is background process in Oracle?
What are the various oracle database objects?
What is the fastest query method to fetch data from the table?
How to rename an index?
How to drop a stored procedure in oracle?
What is partitioned table in Oracle?
Can we store pictures in the database and if so, how it can be done?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
Is there a function to split a string in plsql?
What is system global area (sga) in oracle?
