在MySQL中使用SQL 【数据库高效编程 - 学习笔记 第四章】
SELECT * FROM product WHERE price > (SELECT AVG(price) FROM product );/* 子查询,结果,返回单一值 */SELECT name, address FROM user WHERE uid NOT IN ( SELECT uid FROM order_basic WHERE odate = '2010-07-24' );/* 子查询,返回多个值 */SELECT name, address FROM user WHERE EXISTS ( SELECT * FROM order_basic WHERE user.uid = order_basic.uid );/* 相关子查询 */