数据库实验四——嵌套SQL查询
一.实验步骤
任选以上步骤中创建好的表格, 自己设计问题, 逐一展示如下命令的用法.
(1)Set Operations: union, intersect, except
先执行语句:
select*
from instructor
where salary>100000
找出教工表里薪水大于100000的教师,结果如下:
再执行语句:
select*
from instructor
where dept_name='Biology'or dept_name= 'physics'
找出教工表里院系为生物系或物理系的老师,结果如下:
然后对这两个集合做并集,交集,差集:
并集:执行语句:
(select*
from instructor
where salary>100000)
union
(select*
from instructor
where dept_name='Biology'or dept_name= 'physics')
结果如下:
交集:执行语句:
(select*
from instructor
where salary>100000)
intersect
(select*
from instructor
where dept_name='Biology'or dept_name= 'physics')
结果如下:
差集:执行代码:
(select*
from instructor
where salary>100000)
except
(select*
from instructor
where dept_name='Biology&