第三章练习题
3.有两个关系S(A,B,C,D)和 T(C,D,E,F),写出与下列查询等价的SQL表达式:
(1) σ A = 10 ( S ) \sigma_{A=10}(S) σA=10(S)
等价于从S表中选出A=10的元组
Select * From S
Where A = 10
(2) Π A , B ( S ) \Pi_{A,B}(S) ΠA,B(S) 从投影中选出A,B列
Select A, B From S
(3) S ⋈ T S \bowtie T S⋈T
判断C,D是否相等
Select A, B, S.C, S.D, E, F
From S, T
Where S.C = T.C And S.D = T.D
(4) S ⋈ S . C = T . C T S {\underset{S.C=T.C} \bowtie} T SS.C=T.C⋈T等值连接
Select *
From S, T
Where S.C = T.C
(5) S ⋈ A = E T S {\underset{A=E} \bowtie} T SA=E⋈T非等值连接
Select *
From S, T
Where S.A=