HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG
WITH DEPARTMENT NAMES? E.g EMP,DEPT
Answer Posted / harika
select dname,max(sal) from emp e,dept d
where d.deptno=e.deptno
group by d.deptno;
Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
what is IDE,DMV in sql server?
What is a private synonym?
What is the difference between postgresql and oracle?
Explain the use of control file?
How to turn on or off recycle bin for the session?
How to name query output columns in oracle?
What are the different windows events activated at runtime ?
In the oracle version 9.3.0.5.0, what does each number shows?
Explain a synonym?
What is a schema in oracle?
What is the usage of analyze command in oracle?
How to concatenate two text values in oracle?
What do you understand by database schema and what does it hold?
How do I know if oracle is installed on windows?
When do I need to use a semicolon vs a slash in oracle sql?