问题:
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)
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?()
● 参考解析
本题暂无解析