In this method, a column of a 'select' itself is a result of another 'select' query.
%%sql
select e.*,(select d.depcity from deptt_<<your lab username>> d where d.depid = e.depid) dep_city from emp_<<your lab username>> e;
Taking you to the next exercise in seconds...
Want to create exercises like this yourself? Click here.
No hints are availble for this assesment
Answer is not availble for this assesment
Loading comments...