i want department wise maxmum salary and empolyee name
Answer Posted / shiva
select deptno,ename,max(sal)
from emp
group by deptno,ename;
| Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
What is a database schema in oracle?
Explain the importance of .pll extension in oracle?
Why do we need integrity constraints in a database?
Briefly explain what is literal? Give an example where it can be used?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
How can we delete duplicate rows in a table?
What is the sid in oracle?
What are data pump export and import modes?
What is concurrency in oracle?
Explain parameter file in oracle.
What is a read write transaction in oracle?
Explain what are the different type of segments?
How to list all user accounts in oracle?
What is a tns file?
How can you use check constraints for self referential integrity?