Informatics Practices
Assertion. Both WHERE and HAVING clauses work with GROUP BY in a SELECT statement.
Reason. The WHERE clause is applied before forming groups of rows and HAVING clause is applied after forming the groups.
- Both A and R are true and R is the correct explanation of A.
- Both A and R are true but R is not the correct explanation of A.
- A is true but R is false.
- A is false but R is true.
SQL Queries
1 Like
Answer
Both A and R are true and R is the correct explanation of A.
Explanation
Both the WHERE and HAVING clauses can be used with the GROUP BY clause in a SELECT statement to filter and specify conditions for rows and groups, respectively. The WHERE clause filters rows before they are grouped, while the HAVING clause filters groups of rows after they have been grouped by the GROUP BY clause. This is because WHERE conditions cannot include aggregate functions, whereas HAVING conditions can include them.
Answered By
3 Likes
Related Questions
Assertion. The GROUP BY clause can use any type of function.
Reason. The GROUP BY clause combines a number of rows in a group and applies functions on it.
- Both A and R are true and R is the correct explanation of A.
- Both A and R are true but R is not the correct explanation of A.
- A is true but R is false.
- A is false but R is true.
Assertion. The GROUP BY clause yields summary results using group functions.
Reason. The GROUP BY clause combines a number of rows in a group and applies functions on it.
- Both A and R are true and R is the correct explanation of A.
- Both A and R are true but R is not the correct explanation of A.
- A is true but R is false.
- A is false but R is true.
Assertion. Both WHERE and HAVING clauses are used to specify conditions.
Reason. The WHERE and HAVING clauses are interchangeable.
Assertion. Both WHERE and HAVING clauses are used for specifying conditions.
Reason. The WHERE condition is applicable on individual rows and HAVING condition is applicable on a group of rows.
- Both A and R are true and R is the correct explanation of A.
- Both A and R are true but R is not the correct explanation of A.
- A is true but R is false.
- A is false but R is true.