#having clause

SQL Aggregate Functions | Queries with Aggregates

Sql Aggregate functions provide a way to find answer like “How many movies are directed by John Lasseter?”, or “Which movie has the highest sales?”  in movie database. This function is also helpful to summarise information about a group of rows of data.

Sql provides various aggregate functions. Here we will discuss few of them which are very common:

COUNT(col-name) – Returns the number of…