subquery

Speech parts

1. subquery - Noun

2. subquery - Verb

Meaning

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.

Source: en.wiktionary.org

Examples

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

Close letter words and terms

subquantum subquark subqubit subquest subquestion subquinquefid