A Subquery or Inner query or Nested query is a query within another SQL query and embedded within the WHERE clause.
A subquery is used to return data that will be used in the main query as a condition to further restrict the data to be retrieved.
Subqueries can be used with the SELECT, INSERT, UPDATE, and DELETE statements along with the operators like =, <, >, >=, <=, IN, BETWEEN etc.
SELECT * FROM Employee WHERE Emp_ID IN (SELECT Emp_ID FROM Employee WHERE Emp_Sal > 1000)
Don't want to miss updates? Please click the below button!
Copyright © 2010 - 2015 MindStick Software Pvt. Ltd. All Rights Reserved.