Nested Subqueries 嵌套子查询 ; 巢式子查询
Correlated Subqueries 关联子查询
single-row subqueries 单行子查询
scalar subqueries 标量子查询
multiple-row subqueries 多行子查询
Using Correlated Subqueries 使用相互关系子查询
There are two types of subqueries, uncorrelated and correlated.
有两种类型的子查询： 不相关的 和 相关的。
This tutorial describes subqueries stated as conditions in the WHERE clause, which are useful for simpler comparison queries.
本教程描述在 WHERE 子句中作为条件的子查询，这些子查询对于较简单的比较查询很有用。
Syntactically, subqueries are enclosed within parentheses. For example, the following SELECT statement contains a simple subquery in its WHERE clause
从语法上来说, 子查询被包含在圆括号中.
应用推荐