select deptno,dname,max(sal) dept_max from (select empno, e.deptno,

two tables are there
emp(eno,ename,sal,deptno),dept(deptno,dname).how form the
query in deptno,ename,max(sal)

Question Posted / no_name

2 Answers
5061 Views
I also Faced
E-Mail Answers

Answer Posted / no_name

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

Is This Answer Correct ?

2 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Write a syntax for update query in oracle?

1076

How to delete a column in an existing table in oracle?

1130

What is a static data dictionary in oracle?

1192

What is oracle used for?

1071

Use of an integrity constraint is better to validate data. Explain

1089

Explain enable novalidate constraint.

1132

What is a snapshot log?

1051

Explain view?

1091

What are the various oracle database objects?

1204

How to check the server version in oracle?

1144

What do you mean by cdb and pdb in oracle 12c?

1102

How to create tables for odbc connection testing?

1209

Explain what does a control file contain?

1166

How can windows applications connect to oracle servers?

1118

How can we view last record added to a table?

1108