The ROW NUMBER Window Function and its implementations | SQL Server
In this video, we'll cover the ROW NUMBER Window Function. This function allows us to rank a set of numerical values based on a sorting-criteria. As we demonstrate how this function works, we'll also look at some of its most used practical implementations.
0:00 - Intro
0:10 - The ROW NUMBER function
3:08 - Pagination using the ROW NUMBER function
4:35 - Dynamic Pagination using a Stored Procedure
6:09 - Finding duplicates or multiple occurrences of the same value
8:10 - Finding the top-N results for each partition
This video is part of the Advanced T-SQL: Window Functions for Advanced Querying course on Udemy.
https://www.udemy.com/course/sql-wind... (67% off)
Since window functions are part of the SQL standard specification, all concepts covered in this video/course can be applied to other relational database management systems that use SQL. So, these aren't limited to only SQL Server.
#sql #WindowFunctions #RowNumber
Sur cette page du site, vous pouvez voir la vidéo en ligne The ROW NUMBER Window Function and its implementations | SQL Server durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur KeepLearningIT 31 décembre 2020, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 6,499 fois et il a aimé 162 téléspectateurs. Bon visionnage!
