A、ORDER BY SALARY > 5000
B、GROUP BY SALARY > 5000
C、HAVING SALARY > 5000
D、WHERE SALARY > 5000
更多“Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000?（）”相关的问题
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、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、 They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause. B、 They are evaluated by the first WHEN clause. If the condition is true， then the row would be evaluated by the subsequent WHEN clauses. C、 They are evaluated by the first WHEN clause. If the condition is false， then the row would be evaluated by the subsequent WHEN clauses. D、 The INSERT statement would give an error because the ELSE clause is not present for support in case none of the WHEN clauses are true.
A、A. They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause. B、B. They are evaluated by the first WHEN clause. If the condition is true， then the row would be evaluated by the subsequent WHEN clauses. C、C. They are evaluated by the first WHEN clause. If the condition is false， then the row would be evaluated by the subsequent WHEN clauses. D、D. The INSERT statement would give an error because the ELSE clause is not present for support in case none of the WHEN clauses are true.
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、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、ORDER BY SALARY > 5000 B、GROUP BY SALARY > 5000 C、HAVING SALARY > 5000 D、WHERE SALARY > 5000
客服
TOP
查看正确答案
