|
|
|
|
|
|
|
|
|
|
version 11
SELECT [ALL | DISTINCT]
{* | select_item, ..., select_item}
FROM table_reference, ..., table_reference
[WHERE search_condition]
[GROUP BY sort_list]
[HAVING search_condition]
[LIMIT {int_number | ALL}]
[OFFSET int_number]
Description
A subquery is like a separate SELECT statement enclosed in parentheses and passed in the predicate of another SQL statement (SELECT, INSERT, UPDATE or DELETE). It acts as a query within a query and is often passed as part of a WHERE or HAVING clause.
See Also
search_condition, SELECT, select_item, sort_list, table_reference.
|
|
|
|
|
|
|
|
|
|