Q 50. Explain SQL Having statement?
Ans : HAVING is used to specify a condition for a group or an aggregate function used in the select statement.
The WHERE clause selects before grouping. The HAVING clause selects rows after grouping. Unlike the HAVING clause, the WHERE clause cannot contain aggregate functions.
No comments:
Post a Comment