【0045】SQL查询--集合运算（并 UNION）

最新推荐文章于 2024-07-31 23:46:36 发布

FlashKoo

最新推荐文章于 2024-07-31 23:46:36 发布

阅读量258

点赞数

分类专栏： sql

本文链接：https://blog.csdn.net/qq_32486599/article/details/73690981

版权

sql 专栏收录该内容

21 篇文章 0 订阅

订阅专栏

SELECT
student.studentNo,
student.birthday,
class.className,
class.institute
FROM
class

INNER JOIN student ON student.classNo = class.classNo
WHERE
class.institute = '信息管理学院' AND
year(student.birthday) = 1990

UNION 

SELECT
student.studentNo,
student.birthday,
class.className,
class.institute
FROM
class

INNER JOIN student ON student.classNo = class.classNo
WHERE
class.institute = '会计学院' AND
year(student.birthday) = 1991

等价于

SELECT
student.studentNo,
student.birthday,
class.className,
class.institute
FROM
class

INNER JOIN student ON student.classNo = class.classNo
WHERE
	(class.institute = '信息管理学院' AND year(student.birthday) = 1990) OR (class.institute = '会计学院' AND year(student.birthday) = 1991)
ORDER BY class.institute DESC