Computer Science
The sum(), if used in a condition, is used with …………… clause.
- Group by
- With
- Where
- Having
Answer
Having
Reason — When using the SUM() function in a condition, it is used with the HAVING clause. The HAVING clause is used to apply conditions to groups of rows after the GROUP BY operation has been performed, making it suitable for conditions involving aggregate functions like SUM().
Related Questions
The functions which work with individual rows' data are called …………… function.
- Single row
- Multiple rows
- Aggregate
- None of these
Function count() is a/an …………… function.
- Single row
- Multiple rows
- Aggregate
- None of these
Which clause cannot be used with "aggregate functions" ?
- GROUP BY
- SELECT
- WHERE
- Both (1) and (3)
What is the meaning of "WHERE" clause in a GROUP BY query ?
- To filter out the summary groups
- To filter out the column groups
- To filter out the row and column values before creating groups
- None of the mentioned