LATERAL Inline View

select deptno,round(avg(sal),2) avg_sal from emp group by deptno;

 

select * from dept,

(select deptno,round(avg(sal),2) avg_sal from emp group by deptno);

 

select * from dept,

(select deptno,round(avg(sal),2) avg_sal from emp group by deptno)d

where d.deptno=dept.deptno;

 

 

select dept.deptno,dname,avg_sal  from dept,

(select deptno,round(avg(sal),2) avg_sal from emp group by deptno)d

where d.deptno=dept.deptno;

------------------------------------------------------------------------------------------

select deptno,dname,

(select round(avg(sal),2) from emp where dept.deptno=emp.deptno)avg_sal

from dept;

--------------------------------------------------------------------------------------------

 

 

select dept.deptno,dname,avg_sal from dept,

lateral(select round(avg(sal),2) avg_sal from emp where emp.deptno=dept.deptno

group by deptno);