134.Where can subqueries be used? (Choose all that apply.)
A.field names in the SELECT statement
B.the FROM clause in the SELECT statement
C.the HAVING clause in the SELECT statement
D.the GROUP BY clause in the SELECT statement
E.the WHERE clause in only the SELECT statement
F.the WHERE clause in SELECT as well as all DML statements
答案:ABCF
解析:group by是要进行分组的,不能使用子查询,E说的是仅仅,肯定是错的
A.field names in the SELECT statement
B.the FROM clause in the SELECT statement
C.the HAVING clause in the SELECT statement
D.the GROUP BY clause in the SELECT statement
E.the WHERE clause in only the SELECT statement
F.the WHERE clause in SELECT as well as all DML statements
答案:ABCF
解析:group by是要进行分组的,不能使用子查询,E说的是仅仅,肯定是错的