带In关键字的子查询
SELECT * FROM t_book WHERE booktypeId IN (SELECT id FROM t_booktype);
SELECT * FROM t_book WHERE booktypeId NOT IN (SELECT id FROM t_booktype);
带比较运算符的子查询
SELECT * FROM t_book WHERE price>=(SELECT price FROM t_pricelevel WHERE priceLevel=1);
带Exists关键字的子查询
SELECT * FROM t_book WHERE EXISTS (SELECT * FROM t_booktype);
SELECT * FROM t_book WHERE NOT EXISTS (SELECT * FROM t_booktype);
带Any关键字的子查询
SELECT * FROM t_book WHERE price>= ANY (SELECT price FROM t_pricelevel);
带All关键字的子查询
SELECT * FROM t_book WHERE price>= ALL (SELECT price FROM t_pricelevel);
网友评论