一. 实验目的
1. 掌握连接查询、嵌套查询(IN、EXISTS)的语句构造及其相互转化;
2. 理解和掌握INSERT、UPDATE和DELETE语法结构的各个组成成分,结合嵌套SQL子查询,分别设计几种不同形式的插入、修改和删除数据的语句,并调试成功;
3. 了解视图与基本表的联系与区别。
二. 实验内容及要求
1. 按照《实验四 数据更新和视图 实验说明.doc》中规定的实验任务写出SQL语句,并得出规定的结果。
三. 实验过程及结果
1.use SCT
select distinct S1.Tname as name1,S2.Tname as name2,(S1.salary-S2.salary) as gzce
from Teacher S1,Teacher S2
where S1.Salary>S2.Salary
2.SELECT distinct Sname,S1.Score,S2.Score,(S1.Score-S2.Score) AS CJC
from Student,SC AS S1,SC AS S2
WHERE Student.S#=S1.S# AND S1.S#=S2.S# AND
S1.C#=‘001’ AND S2.C#=‘002’ AN