HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG
WITH DEPARTMENT NAMES? E.g EMP,DEPT
Answer Posted / naveen
SELECT D.DEPTNO,D.DNAME,MAX(SAL) FROM EMP E,DEPT D WHERE
D.DEPTNO=E.DEPTNO GROUP BY D.DEPTNO,D.DNAME;
Is This Answer Correct ? | 17 Yes | 1 No |
Post New Answer View All Answers
When system tablespace is created?
Is it possible to insert comments into sql statements return in the data model editor ?
What is an oracle user role?
How to write date and time interval literals in oracle?
What are the limitations oracle database 10g xe?
Explain the truncate in oracle?
Explain oracle instance.
What is an oracle user account?
What happens if the imported table already exists?
How to view all columns in an existing table?
What is a cursor and what are the steps need to be taken?
Can select statements be used on views in oracle?
What is a trigger oracle?
What are a collation and state the different types of collation sensitivity?
What is proxy method?