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
On this page of the site you can watch the video online The ROW NUMBER Window Function and its implementations | SQL Server with a duration of hours minute second in good quality, which was uploaded by the user KeepLearningIT 31 December 2020, share the link with friends and acquaintances, this video has already been watched 6,499 times on youtube and it was liked by 162 viewers. Enjoy your viewing!
