Halloween Sale: Flat 70% + Addl. 25% Off + 30 Days Extra Lab on all Courses | Use Coupon HS25 in Checkout | Offer Expires In

  Enroll 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...