![v2-8b8ed21d880033940fb34e38a81bbeed_1440w.jpg?source=172ae18b](http://img-02.proxy.5ce.com/view/image?&type=2&guid=426fc682-dd2f-eb11-8da9-e4434bdf6706&url=https://pic2.zhimg.com/v2-8b8ed21d880033940fb34e38a81bbeed_1440w.jpg?source=172ae18b)
【一、视图】 适用情景:频繁使用
![v2-871b3b966f9a1e1a0147f9ee82949683_b.jpg](http://img-03.proxy.5ce.com/view/image?&type=2&guid=426fc682-dd2f-eb11-8da9-e4434bdf6706&url=https://pic4.zhimg.com/v2-871b3b966f9a1e1a0147f9ee82949683_b.jpg)
create view 视图名称(<列1>,<列2>)
as
<select 查询语句>
1.1 视图中存放的是SQL语句,可随原表更新
1.2 在from子句中,使用视图名称代替表名称
注意:避免在视图的基础上再创建视图
不能往视图里插入数据
![v2-90e71a4d1c2c3421a7fb81f1b2d8d84d_b.jpg](http://img-03.proxy.5ce.com/view/image?&type=2&guid=426fc682-dd2f-eb11-8da9-e4434bdf6706&url=https://pic2.zhimg.com/v2-90e71a4d1c2c3421a7fb81f1b2d8d84d_b.jpg)
【二、子查询】 适用情景:偶尔使用
在from子句中直接写定义视图的sql查询语句
![v2-8bdf21cdd947d71871227c9afb2fa653_b.jpg](http://img-02.proxy.5ce.com/view/image?&type=2&guid=426fc682-dd2f-eb11-8da9-e4434bdf6706&url=https://pic4.zhimg.com/v2-8bdf21cdd947d71871227c9afb2fa653_b.jpg)
![v2-f0f3a3eb577ed327ac168fe329454c04_b.jpg](http://img-03.proxy.5ce.com/view/image?&type=2&guid=426fc682-dd2f-eb11-8da9-e4434bdf6706&url=https://pic1.zhimg.com/v2-f0f3a3eb577ed327ac168fe329454c04_b.jpg)
![v2-2f6293712ffa0ee33437ee15959f0415_b.jpg](http://img-01.proxy.5ce.com/view/image?&type=2&guid=426fc682-dd2f-eb11-8da9-e4434bdf6706&url=https://pic2.zhimg.com/v2-2f6293712ffa0ee33437ee15959f0415_b.jpg)
![v2-0a1d93116a798128b669a3668ce16b32_b.jpg](http://img-03.proxy.5ce.com/view/image?&type=2&guid=426fc682-dd2f-eb11-8da9-e4434bdf6706&url=https://pic3.zhimg.com/v2-0a1d93116a798128b669a3668ce16b32_b.jpg)
![v2-d3f91c90ea14de4781cd7855e9a08e20_b.jpg](http://img-01.proxy.5ce.com/view/image?&type=2&guid=426fc682-dd2f-eb11-8da9-e4434bdf6706&url=https://pic1.zhimg.com/v2-d3f91c90ea14de4781cd7855e9a08e20_b.jpg)
![v2-493b9c09de15e6c9315913afb4cb6f7e_b.jpg](http://img-01.proxy.5ce.com/view/image?&type=2&guid=426fc682-dd2f-eb11-8da9-e4434bdf6706&url=https://pic3.zhimg.com/v2-493b9c09de15e6c9315913afb4cb6f7e_b.jpg)
【三、标量子查询】
定义:只能返回一行或一列(单一值)结果的 子查询
where 成绩 between <标量子查询1> and <标量子查询2>
![v2-fa3f3dce969b98b6caec321a31990694_b.jpg](http://img-02.proxy.5ce.com/view/image?&type=2&guid=426fc682-dd2f-eb11-8da9-e4434bdf6706&url=https://pic1.zhimg.com/v2-fa3f3dce969b98b6caec321a31990694_b.jpg)
【四、关联子查询】
![v2-dd69be65bbb4fc1b9eca737a0e85cf90_b.jpg](http://img-02.proxy.5ce.com/view/image?&type=2&guid=426fc682-dd2f-eb11-8da9-e4434bdf6706&url=https://pic1.zhimg.com/v2-dd69be65bbb4fc1b9eca737a0e85cf90_b.jpg)
【五、函数】
![v2-35d9dc9b6d4cba827e2f923ecfc52ad4_b.jpg](http://img-01.proxy.5ce.com/view/image?&type=2&guid=426fc682-dd2f-eb11-8da9-e4434bdf6706&url=https://pic1.zhimg.com/v2-35d9dc9b6d4cba827e2f923ecfc52ad4_b.jpg)
![v2-8723bb0a8a1c0dff363e4dcae7f1eca9_b.jpg](http://img-01.proxy.5ce.com/view/image?&type=2&guid=426fc682-dd2f-eb11-8da9-e4434bdf6706&url=https://pic2.zhimg.com/v2-8723bb0a8a1c0dff363e4dcae7f1eca9_b.jpg)
![v2-1d932308e146d6dc84317ec6a122a0cb_b.jpg](http://img-01.proxy.5ce.com/view/image?&type=2&guid=426fc682-dd2f-eb11-8da9-e4434bdf6706&url=https://pic4.zhimg.com/v2-1d932308e146d6dc84317ec6a122a0cb_b.jpg)
【习题】https://napier.sqlzoo.net/wiki/SELECT_within_SELECT_Tutorial
![v2-76beeed7fd656dd6195abfabdb468398_b.jpg](http://img-03.proxy.5ce.com/view/image?&type=2&guid=426fc682-dd2f-eb11-8da9-e4434bdf6706&url=https://pic1.zhimg.com/v2-76beeed7fd656dd6195abfabdb468398_b.jpg)
![v2-3ba0e525d2311f620377f16f9fb7ea3a_b.jpg](http://img-02.proxy.5ce.com/view/image?&type=2&guid=426fc682-dd2f-eb11-8da9-e4434bdf6706&url=https://pic3.zhimg.com/v2-3ba0e525d2311f620377f16f9fb7ea3a_b.jpg)
![v2-b9228540bea5d46bcff4c0733ea5e271_b.jpg](http://img-01.proxy.5ce.com/view/image?&type=2&guid=426fc682-dd2f-eb11-8da9-e4434bdf6706&url=https://pic2.zhimg.com/v2-b9228540bea5d46bcff4c0733ea5e271_b.jpg)
![v2-602eb9623e9936b4f57a60694b219c86_b.jpg](http://img-03.proxy.5ce.com/view/image?&type=2&guid=426fc682-dd2f-eb11-8da9-e4434bdf6706&url=https://pic3.zhimg.com/v2-602eb9623e9936b4f57a60694b219c86_b.jpg)
![v2-e16cd5d8ea7f1968fe30d6d4e6ae3350_b.jpg](http://img-02.proxy.5ce.com/view/image?&type=2&guid=426fc682-dd2f-eb11-8da9-e4434bdf6706&url=https://pic1.zhimg.com/v2-e16cd5d8ea7f1968fe30d6d4e6ae3350_b.jpg)
![v2-ff96f806c914d6c38c34f98401a50268_b.jpg](http://img-01.proxy.5ce.com/view/image?&type=2&guid=426fc682-dd2f-eb11-8da9-e4434bdf6706&url=https://pic1.zhimg.com/v2-ff96f806c914d6c38c34f98401a50268_b.jpg)
![v2-9d823f0080313ead22a34235c055e4b1_b.jpg](http://img-02.proxy.5ce.com/view/image?&type=2&guid=426fc682-dd2f-eb11-8da9-e4434bdf6706&url=https://pic2.zhimg.com/v2-9d823f0080313ead22a34235c055e4b1_b.jpg)
![v2-ec6557c45f48afbb1dc98c17778b7093_b.jpg](http://img-03.proxy.5ce.com/view/image?&type=2&guid=426fc682-dd2f-eb11-8da9-e4434bdf6706&url=https://pic4.zhimg.com/v2-ec6557c45f48afbb1dc98c17778b7093_b.jpg)
![v2-699afb65f402915576d8efcd41a23bf2_b.jpg](http://img-01.proxy.5ce.com/view/image?&type=2&guid=426fc682-dd2f-eb11-8da9-e4434bdf6706&url=https://pic3.zhimg.com/v2-699afb65f402915576d8efcd41a23bf2_b.jpg)
![v2-025ad0e60c2a0b9ef107c730a61ad17b_b.jpg](http://img-03.proxy.5ce.com/view/image?&type=2&guid=426fc682-dd2f-eb11-8da9-e4434bdf6706&url=https://pic4.zhimg.com/v2-025ad0e60c2a0b9ef107c730a61ad17b_b.jpg)
![v2-e35a6f70e073a93a15d08a7b4abc9d11_b.jpg](http://img-01.proxy.5ce.com/view/image?&type=2&guid=426fc682-dd2f-eb11-8da9-e4434bdf6706&url=https://pic2.zhimg.com/v2-e35a6f70e073a93a15d08a7b4abc9d11_b.jpg)