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
- 10888 Views
- College School Exams Tests, DELL, I also Faced
- E-Mail Answers
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
Explain the use of compress option in exp command.
How to display row numbers with the records?
How can you use check constraints for self referential integrity?
How to connect to oracle using service name instead of sid?
What are the roles of dba?
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 open and close an explicit cursor in oracle?
How do I call oracle stored procedures that take no parameters?
How to view all columns in an existing table?
please explain.. DB architecture ...
What is a partition in oracle?
What are nested tables?
How to loop through a cursor variable?
How to install oracle database 10g xe?
What are the numeric comparison operations?
