在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 );/* 相关子查询 */