Enrollments Open for Advanced Certification Courses on Data Science, ML & AI by E&ICT Academy IIT Roorkee

  Apply Now

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;

No hints are availble for this assesment

Answer is not availble for this assesment

Loading comments...