Interested to Buy Any Domain ? << Click Here >> for more details...
HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG
WITH DEPARTMENT NAMES? E.g EMP,DEPT
- 5 Answers
- 10890 Views
- College School Exams Tests, DELL, I also Faced
- E-Mail Answers
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
What is pragma autonomous transaction in oracle?
How to update values in a table in oracle?
How to create a server parameter file?
query optmization techniques and quwry analyser+projects+ppts
How to view existing locks on the database?
What is a nested table?
What is ceil and floor in oracle?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How to set up autotrace for a user account?
How to commit the current transaction in oracle?
How to select an oracle system id (sid)?
What are the differences between interval year to month and interval day to second?
What is the difference between primary key and unique key and foreign key in oracle?
How to start a specific oracle instance?
How to display row numbers with the records?
