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
- 10631 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 roles of dba?
Which is better Oracle or MS SQL? Why?
How to export data to a csv file?
What is a trigger oracle?
What is rich query?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
How to install oracle database 10g xe?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
What is a sub query and what are the different types of subqueries?
State all possible different index configurations a table can possibly have?
how to join query for one source type is oracle another source type is sql server ?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What are the set operators union, union all, minus & intersect meant to do?
What is a subquery?
What is pragma autonomous transaction in oracle?
