bitalksbi.com
SQL Subquery Examples - MS SQL Practice
SQL Subquery can be used with the SELECT, INSERT, UPDATE, and DELETE statements as an inner query for outer query to be used as a result