问题:
Given that tables T1 and T2 contain the following rows: Table T1:
C1 C2
5 4 5 2 5 5
Table T2: C1 C2 5 1 5 2 5 3
Which of the following queries will return only those rows that exist in T1 and not in T2?()
A . SELECT * FROM T1 MINUS SELECT * FROM T2
B . SELECT * FROM T1 EXCEPT SELECT * FROM T2
C . SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1
D . SELECT * FROM T1 NOT EXISTS SELECT * FROM T2
Given that tables T1 and T2 contain the following rows: Table T1:
C1 C2
5 4 5 2 5 5
Table T2: C1 C2 5 1 5 2 5 3
Which of the following queries will return only those rows that exist in T1 and not in T2?()
● 参考解析
本题暂无解析
相关内容
相关标签