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
- 10882 Views
- College School Exams Tests, DELL, I also Faced
- E-Mail Answers
Answer Posted / rajiv
select dept.dname,max(sal) totalsal from emp,dept where dept.deptno=emp.deptno group by dept.dname;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the built-in functions used for sending Parameters to forms ?
What privilege is needed for a user to create indexes in oracle?
What is an Oracle Instance?
What is backup in Oracle?
Explain compound trigger in oracle?
What is a sub query? Describe its types?
How to write an inner join with the where clause in oracle?
Explain what are the characteristics of data files?
How will you identify oracle database software release?
Explain oracle’s server parameter file.
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
Whats the benefit of dbms_stats over analyze?
Explain the use of constraints option in exp command.
What is a partition in oracle?
What is data file?
