SQL Server Aggregate Functions
In database systems in general and in SQL Server in particular, functions are pieces of code that take zero or one input and return a single output or an array.
Table-Valued Functions which are typically user-defined can return an array, but in-built SQL Server functions are typically Scalar-Valued Functions. The third class of functions in SQL Server are Aggregate-Valued Functions. The MIN and MAX SQL Server functions are Aggregate-Valued Functions.Read More