MIN and MAX Functions | Easy SQL Tutorial
Here we look at the SQL Functions MAX and MIN. It shows how and when to use them and how to use them both together when combined with GROUP BY.
Content:
00:00 Intro
00:50 What is a SQL function
02:00 The MAX Function
02:40 The MIN Function
03:00 Using them together
Overview of the Max and Min function
The SQL MAX and MIN Functions are known as aggregate functions. 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 - what is the maximum value in this result set (MAX) or what is the lowest value in this result set?
Resources
SQL MIN() and MAX() Functions: https://www.w3schools.com/sql/sql_min...
The T-SQL Max Function: https://learn.microsoft.com/en-us/sql...
The T-SQL Min Function: https://learn.microsoft.com/en-us/sql...
SQL Aggregate Functions: https://learn.microsoft.com/en-us/sql...
Sur cette page du site, vous pouvez voir la vidéo en ligne MIN and MAX Functions | Easy SQL Tutorial durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur The SQL Guy 23 juillet 2023, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 33 fois et il a aimé 0 téléspectateurs. Bon visionnage!
