移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

单选题

Given the following two tables: TAB1 R1 A A A B B C C D E TAB2 R2 A A B B C C D Which of the following queries returns the following result set? RETVAL E()

发布日期:2022-07-17

Given the following two tables: TAB1 R1 A A A B B ...
A

SELECT r1 AS retval FROM tab1 INTERSECT SELECT r2 AS retval FROM tab2

B

SELECT r1 AS retval FROM tab1 EXCEPT SELECT r2 AS retval FROM tab2

C

SELECT DISTINCT r1 AS retval FROM tab1, tab2 WHERE r1 <> r2

D

SELECT r1 AS retval FROM tab1 UNION SELECT r2 AS retval FROM tab2

标签: "暂无标签"

题王网让考试变得更简单

扫码关注题王,更多免费功能准备上线!