Given the following two statements about SQL: (a) An SQL query can contain…

PYQ KVS TGT/PGT 2018

Given the following two statements about SQL:

(a) An SQL query can contain HAVING clause only if it has GROUP BY clause.

(b) In an SQL query "SELECT_FROM_WHERE_GROUP BY_HAVING", HAVING is executed before WHERE.

Which of the following is correct?

  1. A.

    (a) and (b) both are true

  2. B.

    (a) is true, (b) is false

  3. C.

    (a) is false, (b) is true

  4. D.

    (a) and (b) both are false

Attempted by 341 students.

Sign up free to check your answer

Sign up free

Explore the full course: Kvs Nvs Tier 2 Computer Science

Loading lesson…