Computer Science
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
SQL Joins & Grouping
2 Likes
Answer
To filter out the summary groups
Reason — The HAVING clause is used to filter out summary groups in a SELECT query that involves aggregate functions and the GROUP BY clause.
Answered By
3 Likes
Related Questions
SQL applies conditions on the groups through …………… clause after groups have been formed.
- Group by
- With
- Where
- Having
Which clause is used with "aggregate functions" ?
- GROUP BY
- SELECT
- WHERE
- Both (1) and (3)
Where and Having clauses can be used interchangeably in SELECT queries ?
- True
- False
- Only in views
- With order by
The operation whose result contains all pairs of tuples from the two relations, regardless of whether their attribute values match.
- Join
- Cartesian product
- Intersection
- Set difference