多做题,通过考试没问题!

IBM认证考试

睦霖题库>其他计算机考试>IBM认证考试

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
答案解析:
进入题库查看解析

微信扫一扫手机做题