Informatics Practices
Which clause is used with "aggregate functions" ?
- GROUP BY
- SELECT
- WHERE
- Both (a) and (c)
SQL Queries
1 Like
Answer
GROUP BY
Reason — Aggregate functions (such as COUNT, SUM, AVG, MAX, MIN) are used with the GROUP BY clause to perform operations on each group of rows. The GROUP BY clause groups rows that have the same values in specified columns into summary rows.
Answered By
1 Like
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