试题详情
- 单项选择题 Given the following two tables: TAB1 C1 C2 1 Antarctica 2 Africa 3 Asia 4 Australia TAB2 CX CY 5 Europe 6 North America 7 South America Which of the following SQL statements will insert all rows found in table TAB2 into table TAB1?（）
A、INSERT INTO tab1 SELECT cx, cy FROM tab2
B、INSERT INTO tab1 VALUES (tab2.cx, tab2.cy)
C、INSERT INTO tab1 VALUES (SELECT cx, cy FROM tab2)
D、INSERT INTO tab1 (c1, c2) VALUES (SELECT cx, cy FROM tab2)
- A
关注下方微信公众号，在线模考后查看
热门试题