Question

Sql provides the ________ technique, which involves placing an inner query within the where or having clause of an outer query.

Answer 1

This is a subquery. These queries allow the user to make two or more queries within the same command, giving the user the ability to find data that will then be used as the arguments for the outermost query. This is typically found with queries that use the SELECT statement, finding data within a table or chart.