Question

Assertion (A): A SELECT command in SQL can have both WHERE and HAVING clauses.

Reasoning (R): WHERE and HAVING clauses are used to check conditions, therefore, these can be used interchangeably.

Mark the correct choice as:

(A) Both A and R are true and R is the correct explanation for A

(B) Both A and R are true and R is not the correct explanation for A

(C) A is True but R is False

(D) A is False but R is True

Answer 1

Correct option is (C) A is True but R is False

A SELECT command in SQL can have both WHERE and HAVING clauses. WHERE and HAVING clauses cannot be used interchangeably.

For example:

SELECT department, COUNT(*)

FROM employees

WHERE salary > 50000

GROUP BY department

HAVING COUNT(*) > 10;