试题详情
单项选择题 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

  • B

  • 关注下方微信公众号，在线模考后查看

热门试题