本文探讨了SQL中子查询可以在哪些地方使用，包括SELECT语句的字段名、FROM子句、HAVING子句以及WHERE子句等，并解释了为何某些位置不适合使用子查询。
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说的是仅仅，肯定是错的
扫一扫
168
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
