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...
En esta página del sitio puede ver el video en línea The Count Function SQL Tutorial de Duración hora minuto segunda en buena calidad , que subió el usuario The SQL Guy 30 julio 2023, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 713 veces y le gustó 4 a los espectadores. Disfruta viendo!
