当前位置：Gxlcms > 数据库问题 > mysql四-2:多表查询

mysql四-2:多表查询

时间：2021-07-01 10:21:17 帮助过：12人阅读

建表 create table department( id int, name varchar(20) ); create table employee( id int primary key auto_increment, name varchar(20), sex enum(‘male‘,‘female‘) not null default ‘male‘, age int, dep_id int ); #插入数据 insert into department values (200,‘技术‘), (201,‘人力资源‘), (202,‘销售‘), (203,‘运营‘); insert into employee(name,sex,age,dep_id) values (‘egon‘,‘male‘,18,200), (‘alex‘,‘female‘,48,201), (‘wupeiqi‘,‘male‘,38,201), (‘yuanhao‘,‘female‘,28,202), (‘liwenzhou‘,‘male‘,18,200), (‘jingliyang‘,‘female‘,18,204) ; #查看表结构和数据 mysql> desc department; +-------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+-------------+------+-----+---------+-------+ | id | int(11) | YES | | NULL | | | name | varchar(20) | YES | | NULL | | +-------+-------------+------+-----+---------+-------+ mysql> desc employee; +--------+-----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------+-----------------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | name | varchar(20) | YES | | NULL | | | sex | enum(‘male‘,‘female‘) | NO | | male | | | age | int(11) | YES | | NULL | | | dep_id | int(11) | YES | | NULL | | +--------+-----------------------+------+-----+---------+----------------+ mysql> select * from department; +------+--------------+ | id | name | +------+--------------+ | 200 | 技术 | | 201 | 人力资源 | | 202 | 销售 | | 203 | 运营 | +------+--------------+ mysql> select * from employee; +----+------------+--------+------+--------+ | id | name | sex | age | dep_id | +----+------------+--------+------+--------+ | 1 | egon | male | 18 | 200 | | 2 | alex | female | 48 | 201 | | 3 | wupeiqi | male | 38 | 201 | | 4 | yuanhao | female | 28 | 202 | | 5 | liwenzhou | male | 18 | 200 | | 6 | jingliyang | female | 18 | 204 | +----+------------+--------+------+--------+ 表department与employee

二多表连接查询

<span style="color: #008000">#</span><span style="color: #008000">重点：外链接语法</span>
<span style="color: #000000">
SELECT 字段列表
    FROM 表1 INNER</span>|LEFT|<span style="color: #000000">RIGHT JOIN 表2
    ON 表1.字段 </span>= 表2.字段;

1 交叉连接：不适用任何匹配条件。生成笛卡尔积

mysql> select * <span style="color: #0000ff">from</span><span style="color: #000000"> employee,department;
</span>+----+------------+--------+------+--------+------+--------------+
| id | name       | sex    | age  | dep_id | id   | name         |
+----+------------+--------+------+--------+------+--------------+
|  1 | egon       | male   |   18 |    200 |  200 | 技术         |
|  1 | egon       | male   |   18 |    200 |  201 | 人力资源     |
|  1 | egon       | male   |   18 |    200 |  202 | 销售         |
|  1 | egon       | male   |   18 |    200 |  203 | 运营         |
|  2 | alex       | female |   48 |    201 |  200 | 技术         |
|  2 | alex       | female |   48 |    201 |  201 | 人力资源     |
|  2 | alex       | female |   48 |    201 |  202 | 销售         |
|  2 | alex       | female |   48 |    201 |  203 | 运营         |
|  3 | wupeiqi    | male   |   38 |    201 |  200 | 技术         |
|  3 | wupeiqi    | male   |   38 |    201 |  201 | 人力资源     |
|  3 | wupeiqi    | male   |   38 |    201 |  202 | 销售         |
|  3 | wupeiqi    | male   |   38 |    201 |  203 | 运营         |
|  4 | yuanhao    | female |   28 |    202 |  200 | 技术         |
|  4 | yuanhao    | female |   28 |    202 |  201 | 人力资源     |
|  4 | yuanhao    | female |   28 |    202 |  202 | 销售         |
|  4 | yuanhao    | female |   28 |    202 |  203 | 运营         |
|  5 | liwenzhou  | male   |   18 |    200 |  200 | 技术         |
|  5 | liwenzhou  | male   |   18 |    200 |  201 | 人力资源     |
|  5 | liwenzhou  | male   |   18 |    200 |  202 | 销售         |
|  5 | liwenzhou  | male   |   18 |    200 |  203 | 运营         |
|  6 | jingliyang | female |   18 |    204 |  200 | 技术         |
|  6 | jingliyang | female |   18 |    204 |  201 | 人力资源     |
|  6 | jingliyang | female |   18 |    204 |  202 | 销售         |
|  6 | jingliyang | female |   18 |    204 |  203 | 运营         |
+----+------------+--------+------+--------+------+--------------+

2 内连接：只连接匹配的行

<span style="color: #008000">#</span><span style="color: #008000">找两张表共有的部分，相当于利用条件从笛卡尔积结果中筛选出了正确的结果</span><span style="color: #008000">
#</span><span style="color: #008000">department没有204这个部门，因而employee表中关于204这条员工信息没有匹配出来</span>
mysql> select employee.id,employee.name,employee.age,employee.sex,department.name <span style="color: #0000ff">from</span> employee inner join department on employee.dep_id=<span style="color: #000000">department.id; 
</span>+----+-----------+------+--------+--------------+
| id | name      | age  | sex    | name         |
+----+-----------+------+--------+--------------+
|  1 | egon      |   18 | male   | 技术         |
|  2 | alex      |   48 | female | 人力资源     |
|  3 | wupeiqi   |   38 | male   | 人力资源     |
|  4 | yuanhao   |   28 | female | 销售         |
|  5 | liwenzhou |   18 | male   | 技术         |
+----+-----------+------+--------+--------------+
<span style="color: #008000">#</span><span style="color: #008000">上述sql等同于</span>
mysql> select employee.id,employee.name,employee.age,employee.sex,department.name <span style="color: #0000ff">from</span> employee,department where employee.dep_id=department.id;

3 外链接之左连接：优先显示左表全部记录

<span style="color: #008000">#</span><span style="color: #008000">以左表为准，即找出所有员工信息，当然包括没有部门的员工</span><span style="color: #008000">
#</span><span style="color: #008000">本质就是：在内连接的基础上增加左边有右边没有的结果</span>
mysql> select employee.id,employee.name,department.name as depart_name <span style="color: #0000ff">from</span> employee left join department on employee.dep_id=<span style="color: #000000">department.id;
</span>+----+------------+--------------+
| id | name       | depart_name  |
+----+------------+--------------+
|  1 | egon       | 技术         |
|  5 | liwenzhou  | 技术         |
|  2 | alex       | 人力资源     |
|  3 | wupeiqi    | 人力资源     |
|  4 | yuanhao    | 销售         |
|  6 | jingliyang | NULL         |
+----+------------+--------------+

4 外链接之右连接：优先显示右表全部记录

<span style="color: #008000">#</span><span style="color: #008000">以右表为准，即找出所有部门信息，包括没有员工的部门</span><span style="color: #008000">
#</span><span style="color: #008000">本质就是：在内连接的基础上增加右边有左边没有的结果</span>
mysql> select employee.id,employee.name,department.name as depart_name <span style="color: #0000ff">from</span> employee right join department on employee.dep_id=<span style="color: #000000">department.id;
</span>+------+-----------+--------------+
| id   | name      | depart_name  |
+------+-----------+--------------+
|    1 | egon      | 技术         |
|    2 | alex      | 人力资源     |
|    3 | wupeiqi   | 人力资源     |
|    4 | yuanhao   | 销售         |
|    5 | liwenzhou | 技术         |
| NULL | NULL      | 运营         |
+------+-----------+--------------+

5 全外连接：显示左右两个表全部记录

<span style="color: #000000">全外连接：在内连接的基础上增加左边有右边没有的和右边有左边没有的结果
</span><span style="color: #008000">#</span><span style="color: #008000">注意：mysql不支持全外连接 full JOIN</span><span style="color: #008000">
#</span><span style="color: #008000">强调：mysql可以使用此种方式间接实现全外连接</span>
select * <span style="color: #0000ff">from</span> employee left join department on employee.dep_id =<span style="color: #000000"> department.id
union
select </span>* <span style="color: #0000ff">from</span> employee right join department on employee.dep_id =<span style="color: #000000"> department.id
;
</span><span style="color: #008000">#</span><span style="color: #008000">查看结果</span>
+------+------------+--------+------+--------+------+--------------+
| id   | name       | sex    | age  | dep_id | id   | name         |
+------+------------+--------+------+--------+------+--------------+
|    1 | egon       | male   |   18 |    200 |  200 | 技术         |
|    5 | liwenzhou  | male   |   18 |    200 |  200 | 技术         |
|    2 | alex       | female |   48 |    201 |  201 | 人力资源     |
|    3 | wupeiqi    | male   |   38 |    201 |  201 | 人力资源     |
|    4 | yuanhao    | female |   28 |    202 |  202 | 销售         |
|    6 | jingliyang | female |   18 |    204 | NULL | NULL         |
| NULL | NULL       | NULL   | NULL |   NULL |  203 | 运营         |
+------+------------+--------+------+--------+------+--------------+
<span style="color: #008000">#</span><span style="color: #008000">注意 union与union all的区别：union会去掉相同的纪录</span>

三符合条件连接查询

<span style="color: #008000">#</span><span style="color: #008000">示例1：以内连接的方式查询employee和department表，并且employee表中的age字段值必须大于25,即找出年龄大于25岁的员工以及员工所在的部门</span>
select employee.name,department.name <span style="color: #0000ff">from</span><span style="color: #000000"> employee inner join department
    on employee.dep_id </span>=<span style="color: #000000"> department.id
    where age </span>> 25<span style="color: #000000">;
</span><span style="color: #008000">#</span><span style="color: #008000">示例2：以内连接的方式查询employee和department表，并且以age字段的升序方式显示</span>
select employee.id,employee.name,employee.age,department.name <span style="color: #0000ff">from</span><span style="color: #000000"> employee,department
    where employee.dep_id </span>=<span style="color: #000000"> department.id
    </span><span style="color: #0000ff">and</span> age > 25<span style="color: #000000">
    order by age asc;</span>

四子查询

<span style="color: #008000">#</span><span style="color: #008000">1：子查询是将一个查询语句嵌套在另一个查询语句中。</span><span style="color: #008000">
#</span><span style="color: #008000">2：内层查询语句的查询结果，可以为外层查询语句提供查询条件。</span><span style="color: #008000">
#</span><span style="color: #008000">3：子查询中可以包含：IN、NOT IN、ANY、ALL、EXISTS 和 NOT EXISTS等关键字</span><span style="color: #008000">
#</span><span style="color: #008000">4：还可以包含比较运算符：= 、 !=、> 、<等</span>

1 带IN关键字的子查询

<span style="color: #008000">#</span><span style="color: #008000">查询平均年龄在25岁以上的部门名</span>
select id,name <span style="color: #0000ff">from</span><span style="color: #000000"> department
    where id </span><span style="color: #0000ff">in</span><span style="color: #000000"> 
        (select dep_id </span><span style="color: #0000ff">from</span> employee group by dep_id having avg(age) > 25<span style="color: #000000">);
</span><span style="color: #008000">#</span><span style="color: #008000">查看技术部员工姓名</span>
select name <span style="color: #0000ff">from</span><span style="color: #000000"> employee
    where dep_id </span><span style="color: #0000ff">in</span><span style="color: #000000"> 
        (select id </span><span style="color: #0000ff">from</span> department where name=<span style="color: #800000">‘</span><span style="color: #800000">技术</span><span style="color: #800000">‘</span><span style="color: #000000">);
</span><span style="color: #008000">#</span><span style="color: #008000">查看不足1人的部门名</span>
select name <span style="color: #0000ff">from</span><span style="color: #000000"> department
    where id </span><span style="color: #0000ff">in</span><span style="color: #000000"> 
        (select dep_id </span><span style="color: #0000ff">from</span> employee group by dep_id having count(id) <=1);

2 带比较运算符的子查询

<span style="color: #008000">#</span><span style="color: #008000">比较运算符：=、!=、>、>=、<、<=、<></span><span style="color: #008000">
#</span><span style="color: #008000">查询大于所有人平均年龄的员工名与年龄</span>
mysql> select name,age <span style="color: #0000ff">from</span> emp where age > (select avg(age) <span style="color: #0000ff">from</span><span style="color: #000000"> emp);
</span>+---------+------+
| name | age |
+---------+------+
| alex | 48 |
| wupeiqi | 38 |
+---------+------+
2 rows <span style="color: #0000ff">in</span> set (0.00<span style="color: #000000"> sec)
</span><span style="color: #008000">#</span><span style="color: #008000">查询大于部门内平均年龄的员工名、年龄</span>
select t1.name,t1.age <span style="color: #0000ff">from</span><span style="color: #000000"> emp t1
inner join 
(select dep_id,avg(age) avg_age </span><span style="color: #0000ff">from</span><span style="color: #000000"> emp group by dep_id) t2
on t1.dep_id </span>=<span style="color: #000000"> t2.dep_id
where t1.age </span>> t2.avg_age;

3 带EXISTS关键字的子查询

EXISTS关字键字表示存在。在使用EXISTS关键字时，内层查询语句不返回查询的记录。
而是返回一个真假值。True或False
当返回True时，外层查询语句将进行查询；当返回值为False时，外层查询语句不进行查询

<span style="color: #008000">#</span><span style="color: #008000">department表中存在dept_id=203，Ture</span>
mysql> select * <span style="color: #0000ff">from</span><span style="color: #000000"> employee
    </span>-><span style="color: #000000">     where exists
    </span>->         (select id <span style="color: #0000ff">from</span> department where id=200<span style="color: #000000">);
</span>+----+------------+--------+------+--------+
| id | name       | sex    | age  | dep_id |
+----+------------+--------+------+--------+
|  1 | egon       | male   |   18 |    200 |
|  2 | alex       | female |   48 |    201 |
|  3 | wupeiqi    | male   |   38 |    201 |
|  4 | yuanhao    | female |   28 |    202 |
|  5 | liwenzhou  | male   |   18 |    200 |
|  6 | jingliyang | female |   18 |    204 |
+----+------------+--------+------+--------+
<span style="color: #008000">#</span><span style="color: #008000">department表中存在dept_id=205，False</span>
mysql> select * <span style="color: #0000ff">from</span><span style="color: #000000"> employee
    </span>-><span style="color: #000000">     where exists
    </span>->         (select id <span style="color: #0000ff">from</span> department where id=204<span style="color: #000000">);
Empty set (</span>0.00 sec)

练习：查询每个部门最新入职的那位员工

<span style="color: #000000">company.employee
    员工id      id                  int             
    姓名        emp_name            varchar
    性别        sex                 enum
    年龄        age                 int
    入职日期     hire_date           date
    岗位        post                varchar
    职位描述     post_comment        varchar
    薪水        salary              double
    办公室       office              int
    部门编号     depart_id           int
</span><span style="color: #008000">#</span><span style="color: #008000">创建表</span>
<span style="color: #000000">create table employee(
id int </span><span style="color: #0000ff">not</span><span style="color: #000000"> null unique auto_increment,
name varchar(</span>20) <span style="color: #0000ff">not</span><span style="color: #000000"> null,
sex enum(</span><span style="color: #800000">‘</span><span style="color: #800000">male</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">female</span><span style="color: #800000">‘</span>) <span style="color: #0000ff">not</span> null default <span style="color: #800000">‘</span><span style="color: #800000">male</span><span style="color: #800000">‘</span>, <span style="color: #008000">#</span><span style="color: #008000">大部分是男的</span>
age int(3) unsigned <span style="color: #0000ff">not</span> null default 28<span style="color: #000000">,
hire_date date </span><span style="color: #0000ff">not</span><span style="color: #000000"> null,
post varchar(</span>50<span style="color: #000000">),
post_comment varchar(</span>100<span style="color: #000000">),
salary double(</span>15,2<span style="color: #000000">),
office int, </span><span style="color: #008000">#</span><span style="color: #008000">一个部门一个屋子</span>
<span style="color: #000000">depart_id int
);
</span><span style="color: #008000">#</span><span style="color: #008000">查看表结构</span>
mysql><span style="color: #000000"> desc employee;
</span>+--------------+-----------------------+------+-----+---------+----------------+
| Field        | Type                  | Null | Key | Default | Extra          |
+--------------+-----------------------+------+-----+---------+----------------+
| id           | int(11)               | NO   | PRI | NULL    | auto_increment |
| name         | varchar(20)           | NO   |     | NULL    |                |
| sex          | enum(<span style="color: #800000">‘</span><span style="color: #800000">male</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">female</span><span style="color: #800000">‘</span>) | NO   |     | male    |                |
| age          | int(3) unsigned       | NO   |     | 28      |                |
| hire_date    | date                  | NO   |     | NULL    |                |
| post         | varchar(50)           | YES  |     | NULL    |                |
| post_comment | varchar(100)          | YES  |     | NULL    |                |
| salary       | double(15,2)          | YES  |     | NULL    |                |
| office       | int(11)               | YES  |     | NULL    |                |
| depart_id    | int(11)               | YES  |     | NULL    |                |
+--------------+-----------------------+------+-----+---------+----------------+
<span style="color: #008000">#</span><span style="color: #008000">插入记录</span><span style="color: #008000">
#</span><span style="color: #008000">三个部门：教学，销售，运营</span>
<span style="color: #000000">insert into employee(name,sex,age,hire_date,post,salary,office,depart_id) values
(</span><span style="color: #800000">‘</span><span style="color: #800000">egon</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">male</span><span style="color: #800000">‘</span>,18,<span style="color: #800000">‘</span><span style="color: #800000">20170301</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">老男孩驻沙河办事处外交大使</span><span style="color: #800000">‘</span>,7300.33,401,1), <span style="color: #008000">#</span><span style="color: #008000">以下是教学部</span>
(<span style="color: #800000">‘</span><span style="color: #800000">alex</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">male</span><span style="color: #800000">‘</span>,78,<span style="color: #800000">‘</span><span style="color: #800000">20150302</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">teacher</span><span style="color: #800000">‘</span>,1000000.31,401,1<span style="color: #000000">),
(</span><span style="color: #800000">‘</span><span style="color: #800000">wupeiqi</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">male</span><span style="color: #800000">‘</span>,81,<span style="color: #800000">‘</span><span style="color: #800000">20130305</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">teacher</span><span style="color: #800000">‘</span>,8300,401,1<span style="color: #000000">),
(</span><span style="color: #800000">‘</span><span style="color: #800000">yuanhao</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">male</span><span style="color: #800000">‘</span>,73,<span style="color: #800000">‘</span><span style="color: #800000">20140701</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">teacher</span><span style="color: #800000">‘</span>,3500,401,1<span style="color: #000000">),
(</span><span style="color: #800000">‘</span><span style="color: #800000">liwenzhou</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">male</span><span style="color: #800000">‘</span>,28,<span style="color: #800000">‘</span><span style="color: #800000">20121101</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">teacher</span><span style="color: #800000">‘</span>,2100,401,1<span style="color: #000000">),
(</span><span style="color: #800000">‘</span><span style="color: #800000">jingliyang</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">female</span><span style="color: #800000">‘</span>,18,<span style="color: #800000">‘</span><span style="color: #800000">20110211</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">teacher</span><span style="color: #800000">‘</span>,9000,401,1<span style="color: #000000">),
(</span><span style="color: #800000">‘</span><span style="color: #800000">jinxin</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">male</span><span style="color: #800000">‘</span>,18,<span style="color: #800000">‘</span><span style="color: #800000">19000301</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">teacher</span><span style="color: #800000">‘</span>,30000,401,1<span style="color: #000000">),
(</span><span style="color: #800000">‘</span><span style="color: #800000">成龙</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">male</span><span style="color: #800000">‘</span>,48,<span style="color: #800000">‘</span><span style="color: #800000">20101111</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">teacher</span><span style="color: #800000">‘</span>,10000,401,1<span style="color: #000000">),
(</span><span style="color: #800000">‘</span><span style="color: #800000">歪歪</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">female</span><span style="color: #800000">‘</span>,48,<span style="color: #800000">‘</span><span style="color: #800000">20150311</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">sale</span><span style="color: #800000">‘</span>,3000.13,402,2),<span style="color: #008000">#</span><span style="color: #008000">以下是销售部门</span>
(<span style="color: #800000">‘</span><span style="color: #800000">丫丫</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">female</span><span style="color: #800000">‘</span>,38,<span style="color: #800000">‘</span><span style="color: #800000">20101101</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">sale</span><span style="color: #800000">‘</span>,2000.35,402,2<span style="color: #000000">),
(</span><span style="color: #800000">‘</span><span style="color: #800000">丁丁</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">female</span><span style="color: #800000">‘</span>,18,<span style="color: #800000">‘</span><span style="color: #800000">20110312</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">sale</span><span style="color: #800000">‘</span>,1000.37,402,2<span style="color: #000000">),
(</span><span style="color: #800000">‘</span><span style="color: #800000">星星</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">female</span><span style="color: #800000">‘</span>,18,<span style="color: #800000">‘</span><span style="color: #800000">20160513</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">sale</span><span style="color: #800000">‘</span>,3000.29,402,2<span style="color: #000000">),
(</span><span style="color: #800000">‘</span><span style="color: #800000">格格</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">female</span><span style="color: #800000">‘</span>,28,<span style="color: #800000">‘</span><span style="color: #800000">20170127</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">sale</span><span style="color: #800000">‘</span>,4000.33,402,2<span style="color: #000000">),
(</span><span style="color: #800000">‘</span><span style="color: #800000">张野</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">male</span><span style="color: #800000">‘</span>,28,<span style="color: #800000">‘</span><span style="color: #800000">20160311</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">operation</span><span style="color: #800000">‘</span>,10000.13,403,3), <span style="color: #008000">#</span><span style="color: #008000">以下是运营部门</span>
(<span style="color: #800000">‘</span><span style="color: #800000">程咬金</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">male</span><span style="color: #800000">‘</span>,18,<span style="color: #800000">‘</span><span style="color: #800000">19970312</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">operation</span><span style="color: #800000">‘</span>,20000,403,3<span style="color: #000000">),
(</span><span style="color: #800000">‘</span><span style="color: #800000">程咬银</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">female</span><span style="color: #800000">‘</span>,18,<span style="color: #800000">‘</span><span style="color: #800000">20130311</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">operation</span><span style="color: #800000">‘</span>,19000,403,3<span style="color: #000000">),
(</span><span style="color: #800000">‘</span><span style="color: #800000">程咬铜</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">male</span><span style="color: #800000">‘</span>,18,<span style="color: #800000">‘</span><span style="color: #800000">20150411</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">operation</span><span style="color: #800000">‘</span>,18000,403,3<span style="color: #000000">),
(</span><span style="color: #800000">‘</span><span style="color: #800000">程咬铁</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">female</span><span style="color: #800000">‘</span>,18,<span style="color: #800000">‘</span><span style="color: #800000">20140512</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">operation</span><span style="color: #800000">‘</span>,17000,403,3<span style="color: #000000">)
;
</span><span style="color: #008000">#</span><span style="color: #008000">ps：如果在windows系统中，插入中文字符，select的结果为空白，可以将所有字符编码统一设置成gbk</span>

准备表和记录

<span style="color: #000000">SELECT
    </span>*<span style="color: #000000">
FROM
    emp AS t1
INNER JOIN (
    SELECT
        post,
        max(hire_date) max_date
    FROM
        emp
    GROUP BY
        post
) AS t2 ON t1.post </span>=<span style="color: #000000"> t2.post
WHERE
    t1.hire_date </span>= t2.max_date;

答案一（链表）

mysql> select (select t2.name <span style="color: #0000ff">from</span> emp as t2 where t2.post=t1.post order by hire_date desc limit 1) <span style="color: #0000ff">from</span><span style="color: #000000"> emp as t1 group by post;
</span>+---------------------------------------------------------------------------------------+
| (select t2.name <span style="color: #0000ff">from</span> emp as t2 where t2.post=t1.post order by hire_date desc limit 1) |
+---------------------------------------------------------------------------------------+
| 张野                                                                                  |
| 格格                                                                                  |
| alex                                                                                  |
| egon                                                                                  |
+---------------------------------------------------------------------------------------+<span style="color: #000000">
rows </span><span style="color: #0000ff">in</span> set (0.00<span style="color: #000000"> sec)
mysql</span>> select (select t2.id <span style="color: #0000ff">from</span> emp as t2 where t2.post=t1.post order by hire_date desc limit 1) <span style="color: #0000ff">from</span><span style="color: #000000"> emp as t1 group by post;
</span>+-------------------------------------------------------------------------------------+
| (select t2.id <span style="color: #0000ff">from</span> emp as t2 where t2.post=t1.post order by hire_date desc limit 1) |
+-------------------------------------------------------------------------------------+
|                                                                                  14 |
|                                                                                  13 |
|                                                                                   2 |
|                                                                                   1 |
+-------------------------------------------------------------------------------------+<span style="color: #000000">
rows </span><span style="color: #0000ff">in</span> set (0.00<span style="color: #000000"> sec)
</span><span style="color: #008000">#</span><span style="color: #008000">正确答案</span>
mysql> select t3.name,t3.post,t3.hire_date <span style="color: #0000ff">from</span> emp as t3 where id <span style="color: #0000ff">in</span> (select (select id <span style="color: #0000ff">from</span> emp as t2 where t2.post=t1.post order by hire_date desc limit 1) <span style="color: #0000ff">from</span><span style="color: #000000"> emp as t1 group by post);
</span>+--------+-----------------------------------------+------------+
| name   | post                                    | hire_date  |
+--------+-----------------------------------------+------------+
| egon   | 老男孩驻沙河办事处外交大使              | 2017-03-01 |
| alex   | teacher                                 | 2015-03-02 |
| 格格   | sale                                    | 2017-01-27 |
| 张野   | operation                               | 2016-03-11 |
+--------+-----------------------------------------+------------+<span style="color: #000000">
rows </span><span style="color: #0000ff">in</span> set (0.00 sec)

答案二（子查询）

答案一为正确答案，答案二中的limit 1有问题（每个部门可能有>1个为同一时间入职的新员工），我只是想用该例子来说明可以在select后使用子查询

可以基于上述方法解决：比如某网站在全国各个市都有站点，每个站点一条数据，想取每个省下最新的那一条市的网站质量信息

五综合练习

init.sql文件内容

/*<span style="color: #000000">
 数据导入：
 Navicat Premium Data Transfer
 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : </span>50624<span style="color: #000000">
 Source Host           : localhost
 Source Database       : sqlexam
 Target Server Type    : MySQL
 Target Server Version : </span>50624<span style="color: #000000">
 File Encoding         : utf</span>-8<span style="color: #000000">
 Date: </span>10/21/2016 06:46:46<span style="color: #000000"> AM
</span>*/<span style="color: #000000">
SET NAMES utf8;
SET FOREIGN_KEY_CHECKS </span>=<span style="color: #000000"> 0;
</span>-- ----------------------------
--  Table structure <span style="color: #0000ff">for</span> `<span style="color: #0000ff">class</span><span style="color: #000000">`
</span>-- ----------------------------<span style="color: #000000">
DROP TABLE IF EXISTS `</span><span style="color: #0000ff">class</span><span style="color: #000000">`;
CREATE TABLE `</span><span style="color: #0000ff">class</span><span style="color: #000000">` (
  `cid` int(</span>11<span style="color: #000000">) NOT NULL AUTO_INCREMENT,
  `caption` varchar(</span>32<span style="color: #000000">) NOT NULL,
  PRIMARY KEY (`cid`)
) ENGINE</span>=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=<span style="color: #000000">utf8;
</span>-- ----------------------------
--  Records of `<span style="color: #0000ff">class</span><span style="color: #000000">`
</span>-- ----------------------------<span style="color: #000000">
BEGIN;
INSERT INTO `</span><span style="color: #0000ff">class</span>` VALUES (<span style="color: #800000">‘</span><span style="color: #800000">1</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">三年二班</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">2</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">三年三班</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">3</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">一年二班</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">4</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">二年九班</span><span style="color: #800000">‘</span><span style="color: #000000">);
COMMIT;
</span>-- ----------------------------
--  Table structure <span style="color: #0000ff">for</span><span style="color: #000000"> `course`
</span>-- ----------------------------<span style="color: #000000">
DROP TABLE IF EXISTS `course`;
CREATE TABLE `course` (
  `cid` int(</span>11<span style="color: #000000">) NOT NULL AUTO_INCREMENT,
  `cname` varchar(</span>32<span style="color: #000000">) NOT NULL,
  `teacher_id` int(</span>11<span style="color: #000000">) NOT NULL,
  PRIMARY KEY (`cid`),
  KEY `fk_course_teacher` (`teacher_id`),
  CONSTRAINT `fk_course_teacher` FOREIGN KEY (`teacher_id`) REFERENCES `teacher` (`tid`)
) ENGINE</span>=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=<span style="color: #000000">utf8;
</span>-- ----------------------------
--<span style="color: #000000">  Records of `course`
</span>-- ----------------------------<span style="color: #000000">
BEGIN;
INSERT INTO `course` VALUES (</span><span style="color: #800000">‘</span><span style="color: #800000">1</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">生物</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">1</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">2</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">物理</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">2</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">3</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">体育</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">3</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">4</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">美术</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">2</span><span style="color: #800000">‘</span><span style="color: #000000">);
COMMIT;
</span>-- ----------------------------
--  Table structure <span style="color: #0000ff">for</span><span style="color: #000000"> `score`
</span>-- ----------------------------<span style="color: #000000">
DROP TABLE IF EXISTS `score`;
CREATE TABLE `score` (
  `sid` int(</span>11<span style="color: #000000">) NOT NULL AUTO_INCREMENT,
  `student_id` int(</span>11<span style="color: #000000">) NOT NULL,
  `course_id` int(</span>11<span style="color: #000000">) NOT NULL,
  `num` int(</span>11<span style="color: #000000">) NOT NULL,
  PRIMARY KEY (`sid`),
  KEY `fk_score_student` (`student_id`),
  KEY `fk_score_course` (`course_id`),
  CONSTRAINT `fk_score_course` FOREIGN KEY (`course_id`) REFERENCES `course` (`cid`),
  CONSTRAINT `fk_score_student` FOREIGN KEY (`student_id`) REFERENCES `student` (`sid`)
) ENGINE</span>=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=<span style="color: #000000">utf8;
</span>-- ----------------------------
--<span style="color: #000000">  Records of `score`
</span>-- ----------------------------<span style="color: #000000">
BEGIN;
INSERT INTO `score` VALUES (</span><span style="color: #800000">‘</span><span style="color: #800000">1</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">1</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">1</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">10</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">2</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">1</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">2</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">9</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">5</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">1</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">4</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">66</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">6</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">2</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">1</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">8</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">8</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">2</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">3</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">68</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">9</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">2</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">4</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">99</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">10</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">3</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">1</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">77</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">11</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">3</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">2</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">66</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">12</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">3</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">3</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">87</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">13</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">3</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">4</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">99</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">14</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">4</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">1</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">79</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">15</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">4</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">2</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">11</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">16</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">4</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">3</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">67</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">17</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">4</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">4</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">100</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">18</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">5</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">1</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">79</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">19</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">5</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">2</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">11</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">20</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">5</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">3</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">67</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">21</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">5</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">4</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">100</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">22</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">6</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">1</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">9</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">23</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">6</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">2</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">100</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">24</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">6</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">3</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">67</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">25</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">6</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">4</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">100</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">26</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">7</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">1</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">9</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">27</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">7</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">2</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">100</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">28</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">7</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">3</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">67</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">29</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">7</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">4</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">88</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">30</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">8</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">1</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">9</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">31</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">8</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">2</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">100</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">32</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">8</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">3</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">67</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">33</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">8</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">4</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">88</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">34</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">9</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">1</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">91</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">35</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">9</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">2</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">88</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">36</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">9</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">3</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">67</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">37</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">9</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">4</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">22</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">38</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">10</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">1</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">90</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">39</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">10</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">2</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">77</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">40</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">10</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">3</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">43</span><span style="color: #800000">‘</span>), (<span style="color: #800000">‘</span><span style="color: #800000">41</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">10</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">4</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">87</span><span style="c                    </div>
                  
 
                    <div class=" "="">
                        <ul class="m-news-opt fix">
                            <li class="opt-item">
                                <a href="/sql_question-410958.html" target="_blank"><p>< 上一篇</p><p class="ellipsis">远程sql 同步程序</p></a>
                            </li>
                            <li class="opt-item ta-r">
                                 <a href="/sql_question-410960.html" target="_blank"><p>下一篇 ></p><p class="ellipsis">sql查询作业答案</p></a>
                            </li>
                        </ul>
                    </span>

mysql四-2:多表查询

二 多表连接查询

三 符合条件连接查询

四 子查询

五 综合练习

人气教程排行

二多表连接查询

三符合条件连接查询

四子查询

五综合练习