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
На этой странице сайта вы можете посмотреть видео онлайн The ROW NUMBER Window Function and its implementations | SQL Server длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь KeepLearningIT 31 Декабрь 2020, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 6,499 раз и оно понравилось 162 зрителям. Приятного просмотра!
