A、in the INTO clause of an INSERT statement
B、in the FROM clause of a SELECT statement
C、in the GROUP BY clause of a SELECT statement
D、in the WHERE clause of a SELECT statement
E、in the SET clause of an UPDATE statement
F、in the VALUES clause of an INSERT statement
更多“In which four clauses can a subquery be used? （）”相关的问题
A、in the INTO clause of an INSERT statement B、in the FROM clause of a SELECT statement C、in the GROUP BY clause of a SELECT statement D、in the WHERE clause of a SELECT statement E、in the SET clause of an UPDATE statement F、in the VALUES clause of an INSERT statement
A、All fields in each match clause must match. B、All match clauses in the CLACL must match. C、Only asingle field in each match clause must match. D、Only asingle match clause in the CLACL must match
A、A table referenced in the FROM clause has no indexed column. B、The table referenced in the FROM clause has more than 200 columns. C、Two or more tables in the FROM clause have identical column names. D、The FROM clause contains two or more tables in the SELECT statement.
A、The sort is in ascending by order by default. B、The sort is in descending order by default. C、The ORDER BY clause must precede the WHERE clause. D、The ORDER BY clause is executed on the client side. E、The ORDER BY clause comes last in the SELECT statement. F、The ORDER BY clause is executed first in the query execution.
A、The sort is in ascending by order by default. B、The sort is in descending order by default. C、The ORDER BY clause must precede the WHERE clause. D、The ORDER BY clause is executed on the client side. E、The ORDER BY clause comes last in the SELECT statement. F、The ORDER BY clause is executed first in the query execution.
A、The sort is in ascending by order by default. B、The sort is in descending order by default. C、The ORDER BY clause must precede the WHERE clause. D、The ORDER BY clause is executed on the client side. E、The ORDER BY clause comes last in the SELECT statement. F、The ORDER BY clause is executed first in the query execution.
A、A WHERE clause can be used to restrict both rows and groups. B、A WHERE clause can be used to restrict rows only. C、A HAVING clause can be used to restrict both rows and groups. D、A HAVING clause can be used to restrict groups only. E、A WHERE clause CANNOT be used in a query if the query uses a HAVING clause. F、A HAVING clause CANNOT be used in subqueries.
A、A WHERE clause can be used to restrict both rows and groups. B、A WHERE clause can be used to restrict rows only. C、A HAVING clause can be used to restrict both rows and groups. D、A HAVING clause can be used to restrict groups only. E、A WHERE clause CANNOT be used in a query of the query uses a HAVING clause. F、A HAVING clause CANNOT be used in subqueries.
A、A. A WHERE clause can be used to restrict both rows and groups. B、B. A WHERE clause can be used to restrict rows only. C、C. A HAVING clause can be used to restrict both rows and groups. D、D. A HAVING clause can be used to restrict groups only. E、E. A WHERE clause CANNOT be used in a query of the query uses a HAVING clause. F、F. A HAVING clause CANNOT be used in subqueries.
客服
TOP
查看正确答案
