1.14 Retrieving by specifying a SELECT statement in the search condition (subquery)
Subqueries can be used to retrieve data from a table by specifying a SELECT statement in the search condition. This provides a way to make retrieval using a SELECT statement more powerful and flexible, by using a search condition based on the retrieval results obtained in another SELECT statement. The SELECT statement that is specified in the search condition is called a subquery. The following figure shows an example of specifying a subquery:
|
|
![[Figure]](GRAPHICS/F0000046.GIF)
#: You can specify a set function in addition to a column name.
- Description
-
You can retrieve data using a search condition based on the results of a SELECT statement specified in a subquery.
- Note
-
For details about the syntax of subqueries, see 7.3.1 Specification format and rules for subqueries.
- Organization of this section