select dept.dname,max(sal) totalsal from emp,dept where dept.deptno=emp.d

HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG
WITH DEPARTMENT NAMES? E.g EMP,DEPT

Question Posted / rajiv

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

Please Help Members By Posting Answers For Below Questions

Compare and contrast between sql and sql server and explain its various functions?

535

Give the different types of rollback segments.

580

Explain the difference between sap and oracle?

575

Explain oracle insert into command?

632

What is a initialization parameter file in oracle?

584

How to create an oracle testing table?

591

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

1953

Query to retrieve record for a many to many relationship ?

2081

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4021

What is raw datatype in oracle?

583

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1442

What is a directory object?

591

Is a rollback possible to any savepoint?

556

What are the four Oracle system processes that must always be up and running for the database to be useable?

595

Which is better Oracle or MS SQL? Why?

3978