1. subquery - Noun
2. subquery - Verb
subquery (plural subqueries)
(databases) A query embedded within a more extensive query, relating only to the data returned by the parent query.
subquery (third-person singular simple present subqueries, present participle subquerying, simple past and past participle subqueried)
(databases, transitive) To run a subquery upon.
We subqueried the customer data to retrieve only customers based in Europe.
A nested query is also known as a subquery. Source: Internet
Essentially, the inline view is a subquery that can be selected from or joined to. Source: Internet
Since 1999 the SQL standard allows named subqueries called common table expressions (named and designed after the IBM DB2 version 2 implementation; Oracle calls these subquery factoring ). Source: Internet
Inline view An Inline view is the use of referencing an SQL subquery in a FROM clause. Source: Internet
Inline View functionality allows the user to reference the subquery as a table. Source: Internet
If you have a NOT IN with a subquery that returns lots of rows, an EXISTS or NOT EXISTS will usually be faster. Source: Internet