Category: Functions

AVG Function

Official Average Function Documentation The AVG function is an aggregate function which operates on a group of values and returns the average of that group. This video will take you from the simplest example though to partitioning the data. Topics covered include Definition Simplest Form Grouped Example ALL | Distinct Partitioning (Please report any errors…

Read the full article

Transact-SQL Functions Overview

Official Function Documentation In this introductory look at Transact-SQL functions we’ll take a broad overview as to what database functions actually are. We’ll focus on Defining what a Transact-SQL function is Explaining the characteristics of function behaviour We’ll go through the five function categories and look at an example of each After watching this video…

Read the full article