Given that tables T1 and T2 contain the following rows:Table T1: C1 C2 1 4 1 3 1 2Table T2: C1 C2 1 1 1 2 1 3Which of the following queries will return only those rows that exist in both T1 and T2?()

Given that tables T1 and T2 contain the following rows:Table T1: C1 C2 1 4 1 3 1 2Table T2: C1 C2 1 1 1 2 1 3Which of the following queries will return only those rows that exist in both T1 and T2？()

A.SELECT * FROM t1 UNION SELECT * FROM t2

B.SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2

C.SELECT * FROM t1 INTERSECT SELECT * FROM t2

D.SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)

您可能感兴趣的试题

设E为巴拿赫空间，T1，T2均属于（E)，且可换。设 λ∈ρ（T1)∩ρ（T2) 则 R（λ，T1)－R（λ，T2)=（T1－T2)R（λ，T1)R（λ，T2)（

答案解析
Our everyday encounters with language are so natural and so extensive that we rarely con

答案解析
铁磁性颗粒造影剂对质子弛豫时间的影响为A.T1缩短 T2缩短B.T1缩短 T2延长C.T1不变 T2缩短D.T2不

答案解析
Given the lack of fit between gifted students and their schools it is not surprising that

答案解析
高浓度顺磁造影剂对质子弛豫时间的影响为( )A.T1缩短 T2改变不大B.T1缩短 T2延长C.T1延长 T2缩

答案解析
Given that tables T1 and T2 contain the following rows: Table T1:C1 C25 4 5 2 5 5Table T2: C1 C2 5 1 5 2 5 3Which of the following queries will return only those rows that exist in T1 and not in T2?()

答案解析
Which of the following SQL statements will return the year and average salary for all employees hired within a given year that have a salary greater than $30 000?()

答案解析