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...
On this page of the site you can watch the video online The Count Function SQL Tutorial with a duration of hours minute second in good quality, which was uploaded by the user The SQL Guy 30 July 2023, share the link with friends and acquaintances, this video has already been watched 713 times on youtube and it was liked by 4 viewers. Enjoy your viewing!
