试题详情
多项选择题Which two statements about subqueries are true? ()

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.

  • B,D
  • 关注下方微信公众号,在线模考后查看

热门试题