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

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

Question Posted / srikanth

2 Answers
4052 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / ajit

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

Is This Answer Correct ?

4 Yes

2 No

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

Answer / 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