Inline SELECT

In this method, a column of a 'select' itself is a result of another 'select' query.

select e.*,(select d.depcity from deptt d where d.depid = e.depid) dep_city from emp e;

Loading comments...