Which two statements about subqueries are true? (Choose two.)
A. A single row subquery can retrieve data from only one table.
B. A SQL query statement cannot display data from table B that is referred to in its
subquery, unless table B is included in the main query's FROM clause.
C. A SQL query statement can display data from table B that is referred to in its
subquery, without including table B in its own FROM clause.
D. A single row subquery can retrieve data from more than one table.
E. A single row subquery cannot be used in a condition where the LIKE operator is used
for comparison.
F. A multiple-row subquery cannot be used in a condition where the LIKE operator is
used for comparison.
Answer: B, D
Which two statements about subqueries are true? (Choose two.)
A. A single row subquery can retrieve data from only one table.
B. A SQL query statement cannot display data from table B that is referred to in its
subquery, unless table B is included in the main query's FROM clause.
C. A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.
D. A single row subquery can retrieve data from more than one table.
E. A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.
F. A multiple-row subquery cannot be used in an INSERT statement to insert multiple rows at a time.
Answer: B, F
这D答案到底是对还是错啊?谢谢
个人觉得是对的
------解决方案--------------------------------------------------------
第二个F明显是错的呀.insert into select;
select可以返回多行.
另外,第一个的F应该没错吧.
第一个感觉bdf全对,第二个bd
------解决方案--------------------------------------------------------
哪两个有关子查询的陈述是正确的？ （选择两项）。
A. 单行子查询可以只从一个表中检索数据。
B. 一个SQL查询语句不能显示来自表B的数据，除非表B是包含在主查询的FROM子句。
C. 一个SQL查询语句可以显示来自不包括在自己的FROM子句中的B表的数据。
D. 单行子查询可以检索从多个表中的数据。
E. 单行子查询不能用在这样一种情况：使用LIKE运算符进行比较。
F. 多行子查询不能用在一个条件下的LIKE运算符用于比较。
哪两个有关子查询的陈述是正确的？ （选择两项）。
A. 单行子查询可以只从一个表中检索数据。
B. 一个SQL查询语句不能显示来自表B的数据，除非表B是包含在主查询的FROM子句。
c. 一个SQL查询语句可以显示来自不包括在自己的FROM子句中的B表的数据。
D. 单行子查询可以检索从多个表中的数据。
E. 单行子查询不能使用在LIKE条件中来进行比较。
F. 多行子查询不能用在INSERT语句中一次性插入多行。
动动手，自己实践一下便可知
------解决方案--------------------------------------------------------
1：BD
2：BD
2的F，说的是：多行子查询不能用在INSERT语句的一次插入多行
这个是可以的
INSERT INTO TABLE SELECT .....
------解决方案--------------------------------------------------------