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

How to define an external table with a text file?

1076

Why does Oracle not permit the use of PCTUSED with indexes?

2427

Explain the use of record length option in exp command.

1068

How does one get the view definition of fixed views/tables?

1024

How to apply filtering criteria at group level in oracle?

1045

What is archive log in Oracle?

1135

What is a connect identifier?

1045

Explain enable novalidate constraint.

1092

What is tns name?

985

Can we protect our pl/sql source code?

1049

How to write an inner join with the where clause in oracle?

1047

How to create a testing table in oracle?

995

What is a trace file and how is it created in oracle?

1062

Is oracle a programming language?

995

What is the difference between translate and replace?

1070