Category: Aggregate Function

The COUNT() function in SQL Server is a part of the aggregate function used for calculating the total number of rows present in the table. When the result set does not have any rows, it returns NULL. It is usually used with the SELECT statement, and its return type is INT. The COUNT() is a built-in function, which…

The AVG() function in SQL Server is a part of an aggregate function. We use this function to calculate the average value of an expression. This function ignores the NULL values. However, when the result set does not have any rows, it returns NULL. The AVG() is a built-in function usually used with the SELECT statement. This function…

The SUM() function in SQL Server is a type of aggregate function. We use this function to calculate the total summed value in a set of values of a specified column or expression. It is a built-in function, which accepts a single parameter that can be a column or valid expression and returns a single result to…

The MAX() function in SQL Server is a type of aggregate function. It is used to get the maximum or largest value in a group of values of a specified column or expression. It is the most commonly used built-in function in the SQL Server. This function accepts a single parameter that can be a column or…

The MIN() function in SQL Server is a type of aggregate function. It is used to get the minimum or smallest value of a specified column or expression. It is the most commonly used built-in function in the SQL Server. It comes under the numeric function that accepts only one parameter and returns a single result after…