HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG
WITH DEPARTMENT NAMES? E.g EMP,DEPT
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
Compare and contrast between sql and sql server and explain its various functions?
Give the different types of rollback segments.
Explain the difference between sap and oracle?
Explain oracle insert into command?
What is a initialization parameter file in oracle?
How to create an oracle testing table?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
Query to retrieve record for a many to many relationship ?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is raw datatype in oracle?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
What is a directory object?
Is a rollback possible to any savepoint?
What are the four Oracle system processes that must always be up and running for the database to be useable?
Which is better Oracle or MS SQL? Why?