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
- 10892 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 is a table index in oracle?
How to see free space of each tablespace?
What privilege is needed for a user to create tables in oracle?
What are the differences between primary key and unique key?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
Compare and contrast between sql and sql server and explain its various functions?
what is the difference between restoring and recovering?
Explain what does a control file contain?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
Is java required for oracle client?
How to generate query output in html format?
What is a table index?
What is the relation of a user account and a schema in oracle?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
What are the attributes of cursor?
