Optimizing SQL Queries

Sub-queries Subquery, also know as nested query is a query embedded within another SQL statement such as SELECT, WHERE, FROM, JOIN, INSERT, UPDATE, or DELETE to enable retrieval of data from one or more tables based on the results of an inner query. ...