Multi row subquery

       In Multi row subquery, inner query returns 'One or More' row. Based on the inner query result outer query will return output.

Example:

           Employee table

           Department table

SELECT * FROM EMPLOYEE

WHERE Dept_ID IN

(

      SELECT

      DEPTID

      FROM DEPT

)