Computer Science
The HAVING clauses can take any valid SQL function in its condition.
SQL Joins & Grouping
2 Likes
Answer
False
Reason — The HAVING clause can contain either a simple boolean expression (i.e., an expression or condition that results into true or false) or use aggregate function in the having condition.
Answered By
3 Likes
Related Questions
The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.
The HAVING and WHERE clauses are interchangeable.
HAVING clause can only be used if the SELECT query has GROUP BY clause.
With GROUP BY, the select-list of the SELECT statement can only take the group-field and/or aggregate function.