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
- 10482 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 meant by joins? List out the types of joins.
How do I escape a reserved word in oracle?
What is oracle join syntax?
what are actual and formal parameters?
How to load data from external tables to regular tables?
What is a read write transaction in oracle?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
Is there an oracle sql query that aggregates multiple rows into one row?
What is an oracle user role?
Respected sir, Please send me technical questions related to oracle apps..
What to do if the startbd.bat failed to start the xe instance?
What is the best way to do multi-row insert in oracle?
Is truncate autocommit in oracle?
What do you understand by a database object? Can you list a few of them?
When do you get a .pll extension in oracle? Explain its importance
