The Count Function SQL Tutorial
In this tutorial we look at the Count function and some nice simple demos on how to use it. As with most of the tutorials here you can download the AdventureWorks2019 database from Microsoft which I provide a link and tutorial for. From here you can follow along nice and easily!
Content
00:00 Intro
00:42 - Functions Explained!
01:48 - The Count Function
The T-SQL COUNT() Functions is known as an aggregate function. These are used to perform a calculation on a set of values. As with all functions, they return a SINGLE value. Thats their job - you ask as question, they provide you with the answer!
What is a Function
A function is a set of code that has a specific task. They are not able to perform DML statements or change any data, they just perform a calculation and return that value.
In this case you would be asking - how many values do I have in this result set?
Resources
The T-SQL COUNT Function: https://learn.microsoft.com/en-us/sql...
SQL Aggregate Functions: https://learn.microsoft.com/en-us/sql...
