select dname,max(sal) from emp e,dept d where d.deptno=e.deptno group by

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

Question Posted / harika

Answer Posted / harika

select dname,max(sal) from emp e,dept d
where d.deptno=e.deptno
group by d.deptno;

Is This Answer Correct ?

3 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is the difference between translate and replace in oracle?

1171

What is oracle database 10g express edition?

1123

How do you bind variables in oracle?

985

What is hash cluster in oracle?

1176

What is instant client oracle?

1028

Explain coalesce function?

1210

What are the predefined tablespaces in a database?

1088

Explain the use of indexes option in imp command.

1184

What is the string concatenation operator in oracle?

1180

How remove data files before opening a database?

1078

How to define a specific record type?

1088

What is the difference between Delete, Truncate and Drop in Oracle?

1132

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2629

what are archived logs?

2205

How to insert a record into a table?

1076