By yusijia

Updated:

Contents 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32

# 带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关键字的子查询    ANY表示满足任意条件
SELECT * FROM t_book WHERE price>= ANY (SELECT price FROM t_pricelevel);

# 带ALL关键字的子查询    ALL表示满足所有条件
SELECT * FROM t_book WHERE price>= ALL (SELECT price FROM t_pricelevel);
Contents