Informatics Practices
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.
SQL Queries
1 Like
Answer
Both A and R are true but R is not the correct explanation of A.
Explanation
Both WHERE and HAVING clauses are used to specify conditions in a SELECT query, they operate at different levels. The WHERE clause filters rows based on conditions applied to individual rows before grouping, while the HAVING clause filters groups based on conditions applied to the result of aggregation functions after grouping.
Answered By
3 Likes
Related Questions
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.
Assertion. Both WHERE and HAVING clauses are used to specify conditions.
Reason. The WHERE and HAVING clauses are interchangeable.
Anjali writes the following commands with respect to a table employee having fields, empno, name, department, commission :
Command1:
Select count(*) from employee;
Command2:Select count(commission) from employee;She gets the output as 4 for the first command but gets an output 3 for the second command. Explain the output with justification.
What is the use of ORDER BY clause ?