Interested to Buy Any Domain ? << Click Here >> for more details...
i want department wise maxmum salary and empolyee name
- 9 Answers
- 29787 Views
- I also Faced
- E-Mail Answers
Answer Posted / sanjay pradhan
select ename,sal,deptno from emp where (deptno,sal) in
(select deptno,max(sal) from emp group by deptno);
| Is This Answer Correct ? | 15 Yes | 4 No |
Post New Answer View All Answers
What do you mean by a tablespace?
What is an oracle and why it is used?
Explain a private synonyms?
What happens to the indexes if a table is recovered?
How to get maxsal , minsal, ename department wise in single query
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
How do I use unicode codesets with the weblogic jdriver for oracle driver?
What do you know about normalization? Explain in detail?
Explain the use of compress option in exp command.
How do I uninstall oracle client from windows?
Can we protect our pl/sql source code?
What is bulk copy or bcp in oracle?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
Does facebook use oracle?
What is Data Dictionary Cache in Oracle?
