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?
- A.
(a) and (b) both are true
- B.
(a) is true, (b) is false
- C.
(a) is false, (b) is true
- D.
(a) and (b) both are false
Attempted by 341 students.
Sign up free to check your answer
Sign up freeLoading lesson…

