mysql Subqueries

1.把查询后的数据当成一张表
2.吧查询后的数据当成一个（序列）

1.应用

1）where

• 比较= > < >= <= <> !=

SELECT * FROM t1 WHERE column1 = (SELECT column1 FROM t2);

• ANY, IN, SOME
  注意:ANY不好理解，故删去，一律采用IN

operand comparison_operator SOME (subquery)
operand comparison_operator ALL (subquery)
operand IN (subquery)

SELECT * FROM tt
    WHERE b > ANY (2, 4, 6);

SELECT * FROM tt
    WHERE b > ANY (SELECT * FROM ts);

• EXISTS or NOT EXISTS
  判断子查询是否存在，当存在时才执行

SELECT column1 FROM t1 WHERE EXISTS (SELECT * FROM t2);

2）from

SELECT ... FROM (subquery) [AS] tbl_name ...

参考：
https://www.cnblogs.com/feiquan/p/8654171.html