单选题In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement? （）A Immediately after the SELECT clauseB Before the WHERE clauseC Before the FROM clauseD After the ORDER BY clauseE After the WHERE clause

题目

单选题

In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement? （）

Immediately after the SELECT clause

Before the WHERE clause

Before the FROM clause

After the ORDER BY clause

After the WHERE clause

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement? ()

A. Immediately after the SELECT clause

B. Before the WHERE clause

C. Before the FROM clause

D. After the ORDER BY clause

E. After the WHERE clause

参考答案：E

第2题：

The EMP table contains these columns:You need to display the employees who have not been assigned to any department.You write the SELECT statement:What is true about this SQL statement?()

A. The SQL statement displays the desired results.

B. The column in the WHERE clause should be changed to display the desired results.

C. The operator in the WHERE clause should be changed to display the desired results.

D. The WHERE clause should be changed to use an outer join to display the desired results.

参考答案：C

第3题：

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

参考答案：B, D, E, F

第4题：

You need to display the last names of those employees who have the letter "A" as the second character in their names.Which SQL statement displays the required results?（）

A、SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';
B、SELECT last_name FROM EMP WHERE last name ='*A%'
C、SELECT last_name FROM EMP WHERE last name ='_A%';
D、SELECT last_name FROM EMP WHERE last name LIKE '*A%'

正确答案:A

第5题：

Evaluate this SQL statement: SELECT e.emp_name, d.dept_name FROM employees e JOIN departments d USING (department_id) WHERE d.department_id NOT IN (10,40) ORSER BY dept_name; The statement fails when executed. Which change fixes the error? （）

A、remove the ORDER BY clause
B、remove the table alias prefix from the WHERE clause
C、remove the table alias from the SELECT clause
D、prefix the column in the USING clause with the table alias
E、prefix the column in the ORDER BY clause with the table alias
F、replace the condition "d.department_id NOT IN (10,40)" in the WHERE clause with "d.department_id <> 10 AND d.department_id <> 40"

正确答案:C

第6题：

Examine the description of the MARKS table:SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects.Examine this SELECT statement based on the MARKS table:What is the result of the SELECT statement?（）

A. The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject.

B. The statement returns an error at the SELECT clause.

C. The statement returns an error at the WHERE clause.

D. The statement returns an error at the ORDER BY clause.

参考答案：C

第7题：

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,B,D,E

第8题：

Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000? ()

A. ORDER BY SALARY > 5000

B. GROUP BY SALARY > 5000

C. HAVING SALARY > 5000

D. WHERE SALARY > 5000

参考答案：D

第9题：

The accounts receivable department requested an accounts status to allow users to enter either a customer name, customer number, customer phone number and then display the customer out standing balance. You want to restrict the data retrieved based on values entered by the users. Which where clause would you write in the query to select statement to accomplish this task?（）

A、&p_where_clause
B、:p_where_clause
C、WHERE CUST_ID=P_CUST_ID or cust_name=:p_cust_name or cust_phone=:p_cust_phone
D、Where cust_ID=&p_custid cust_name=&p_cust_name or cust_phone=&p_cust_phone

正确答案:A

第10题：

Which two statements are true regarding the ORDER BY clause? （）

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,E

In a SELECT statement that includes a WHERE clause, where is

题目

相似问题和答案

更多相关问题

相关内容