分类标准:
子查询出现的位置:
子查询出现的位置:
子查询的返回值形式:
1 single-value or scalar subquery(子查询作为标量操作数)
2 (single) column subquery
3 (single) row subquery (行子查询)
SELECT * FROM t1 WHERE (1,2) = (SELECT column1, column2 FROM t2);
4 table subquery(from subquery)