Because it acts on the results of the GROUP BY clause, aggregation functions can be used in the HAVING clause predicate. The HAVING clause includes a predicate used to filter rows resulting from the GROUP BY clause.The WHERE clause is applied before the GROUP BY clause. GROUP BY is often used in conjunction with SQL aggregation functions or to eliminate duplicate rows from a result set.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |