Explain SQL Having statement? - www.studyandupdates.com

Saturday

Explain SQL Having statement?

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

Popular Posts