Computer Science
Which clause is used with "aggregate functions" ?
- GROUP BY
- SELECT
- WHERE
- Both (1) and (3)
SQL Joins & Grouping
1 Like
Answer
GROUP BY, SELECT
Reason — Aggregate functions are used with the GROUP BY clause to perform calculations on groups of rows. However, they are also used in the SELECT clause to display the results of aggregate calculations.
Answered By
3 Likes
Related Questions
Aggregate functions can be used in the select list or the …………… clause of a select statement. They cannot be used in a …………… clause.
- Where, having
- Having, where
- Group by, having
- Group by, where
SQL applies conditions on the groups through …………… clause after groups have been formed.
- Group by
- With
- Where
- Having
What is the meaning of "HAVING" clause in SELECT query ?
- To filter out the summary groups
- To filter out the column groups
- To filter out the row and column values
- None of the mentioned
Where and Having clauses can be used interchangeably in SELECT queries ?
- True
- False
- Only in views
- With order by