单选题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?（）
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

相似考题

1.标准SQL基本查询模块的结构是A）SELECT…FROM…ORDER BYB）SELECT…WHERE…GROUP BYC）SELECT…WHERE…HAVINGD）SELECT…FROM…WHERE

2.Evaluate this SQL statement:SELECT e.emp_name, d.dept_nameFROM employees eJOIN departments dUSING (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 clauseB. remove the table alias prefix from the WHERE clauseC. remove the table alias from the SELECT clauseD. prefix the column in the USING clause with the table aliasE. prefix the column in the ORDER BY clause with the table aliasF. replace the condition "d.department_id NOT IN (10,40)" in the WHERE clause with "d.department_id <> 10 AND d.department_id <> 40"

3.In which four clauses can a subquery be used? ()A. in the INTO clause of an INSERT statementB. in the FROM clause of a SELECT statementC. in the GROUP BY clause of a SELECT statementD. in the WHERE clause of a SELECT statementE. in the SET clause of an UPDATE statementF. in the VALUES clause of an INSERT statement

4.对由SELECT—FROM—WHERE—GROUP—ORDER组成的SQL语句，其在被DBMS处理时，各子句的执序次序(43)。A．SELECT—FROM—GROUP—WHERE—ORDERB．FROM—SELECT—WHERE—GROUP—ORDERC．FROM—WHERE—GROUP—SELECT—ORDERD．SELECT—FROM—WHERE—GROUP—ORDER

更多“单选题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”相关问题

  • 第1题：

    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

  • 第2题：

    Exhibit:Examine the data in the EMPLOYEES table.Examine the subquery:SELECT last_nameFROM employeesWHERE salary IN (SELECT MAX(salary)FROM employeesGROUP BY department_id);Which statement is true?()

    A. The SELECT statement is syntactically accurate.

    B. The SELECT statement does not work because there is no HAVING clause.

    C. The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.

    D. The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.


    参考答案：A

  • 第3题：

    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

  • 第4题：

    对由SELECT--FROM—WHERE—GROUP--ORDER组成的SQL语句，其在被DBMS处理时，各子句的执行次序为（）

    • A、SELECT—FROM—GROUP—WHERE—ORDER
    • B、FROM--WHERE——GROUP——ORDER——SELECT
    • C、FROM——WHERE——GROUP——SELECT——ORDER
    • D、SELECT——FROM——WHERE——GROUP——ORDER

    正确答案:C

  • 第5题：

    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

  • 第6题：

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

    • A、It is executed first in the query execution 
    • B、It must be the last clause in the SELECT statement 
    • C、It cannot be used in a SELECT statement containing a HAVING clause
    • D、You cannot specify a column name followed by an expression in this clause 
    • E、You can specify a combination of numeric positions and column names in this clause

    正确答案:B,E

  • 第7题：

    The EMP table contains these columns: LAST NAME VARCHAR2(25) SALARY NUMBER(6,2) DEPARTMENT_ID NUMBER(6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARMENT_ID = NULL; 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

  • 第8题：

    单选题
    Examine the description of the MARKS table: STD_ID NUMBER(4) STUDENT_NAME VARCHAR2(30) SUBJ1 NUMBER(3) SUBJ2 NUMBER(3) SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects. Examine this SELECT statement based on the MARKS table: SELECT subj1+subj2 total_marks, std_id FROM marks WHERE subj1 > AVG(subj1) AND subj2 > AVG(subj2) ORDER BY total_ marks; 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.


    正确答案： D
    解析： 暂无解析

  • 第9题：

    多选题
    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


    正确答案： F,A
    解析： 暂无解析

  • 第10题：

    多选题
    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


    正确答案： C,D
    解析： 暂无解析

  • 第11题：

    单选题
    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


    正确答案： E
    解析： 暂无解析

  • 第12题：

    单选题
    Exhibit: Examine the data in the EMPLOYEES table. Examine the subquery: SELECT last_name FROM employees WHERE salary IN (SELECT MAX(salary) FROM employees GROUP BY department_id); Which statement is true?（）
    A

    The SELECT statement is syntactically accurate.

    B

    The SELECT statement does not work because there is no HAVING clause.

    C

    The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.

    D

    The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.


    正确答案： C
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    对由SELECT--FROM—WHERE—GROUP--ORDER组成的SQL语句，其在被DBMS处理时，各子句的执行次序为()

    A.SELECT—FROM—GROUP—WHERE—ORDER

    B.FROM——SELECT--WHERE——GROUP——ORDER

    C.FROM——WHERE——GROUP——SELECT——ORDER

    D.SELECT——FROM——WHERE——GROUP——ORDER


    答案：C

  • 第16题：

    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

  • 第17题：

    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

  • 第18题：

    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

  • 第19题：

    Where can subqueries be used?（）

    • 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

    正确答案:B,C,F

  • 第20题：

    多选题
    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,D
    解析： 暂无解析

  • 第21题：

    单选题
    The EMP table contains these columns: LAST NAME VARCHAR2(25) SALARY NUMBER(6,2) DEPARTMENT_ID NUMBER(6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARMENT_ID = NULL; 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.


    正确答案： B
    解析： 暂无解析

  • 第22题：

    多选题
    Where can subqueries be used?（）
    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


    正确答案： F,B
    解析： 暂无解析

  • 第23题：

    单选题
    The EMP table contains these columns: LAST NAME VARCHAR2(25) SALARY NUMBER(6,2) DEPARTMENT_ID NUMBER(6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARMENT_ID = NULL; 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
    解析： 暂无解析

相关内容