{"page":"\n\n
\n
\n
\n
\n
\n\nVideo\n
\n

\nMaster SQL for Data Analysis - Sequential Numbers\n

\n
\n
\nGet Free Access for 10 Days!\n
\n
\n
\n
\n
\n
×
\n\n\n
\n\nPublisher:\n\nCurated Video\n\n\n
\n
\nLet's look at another typical use case of a window function: to create a sequential integer number inside a group of rows while deciding how this group will be ordered. This clip is from the chapter \"SQL - Window Functions\" of the series...\nLet's look at another typical use case of a window function: to create a sequential integer number inside a group of rows while deciding how this group will be ordered.

This clip is from the chapter \"SQL - Window Functions\" of the series \"Master SQL for Data Analysis\".This section focuses on one of the most complex structures in SQL, the window functions, which is a powerful tool for more complex projects.\n
\n
\n\n
\n
\n
\n
\n

Resource Details

\n
\n
\n
\n
Curator Rating
\n
\n
\n
\n
\n
\n
Educator Rating
Not yet Rated
\n
\n
\n
\n
\n
Media Length
\n
3:17
\n
\n
\n
\n
\n
Grade
Higher Ed
\n
\n
\n
\n
\n
Subjects
Math
5 more...
\n
\n
\n
\n
\n
Media Type
Instructional Videos
\n
\n
\n
\n
\n
Source:
\n
\nPackt - Data\n\n
\n
\n
\n
\n
\n
Date
\n
2023
\n
\n
\n
\n
\n\n
Language
English
\n
\n
\n
\n
\n
Audiences
For Teacher Use
2 more...
\n
\n
\n
\n
\n
Usage Permissions
Fine Print: Educational Use
\n
\n
\n
\n
\n
\n

Additional Materials

\n
\n\nSign in or Join Now
\" data-title=\"Get Full Access\" data-container=\"body\" rel=\"popover\" tabindex=\"0\" href=\"/subscription/new\">Video Transcript\n
\n
\n\nSign in or Join Now
\" data-title=\"Get Full Access\" data-container=\"body\" rel=\"popover\" tabindex=\"0\" href=\"/subscription/new\">Video Preview\n
\n
\n
\n

Additional Tags

\n
\n
recommender systems, two-tower model, tensorflow, neural network models, neural collaborative filtering, variational autoencoders, amazon product recommendation system, window function, sequential number, row number, inline view, oldest user, result set, user, column, create, ordered, query, section, partition, based, result, artition, city, order, case, rows, grou, assign, understand, moving, start, meaning, filter, equal
\n
\n\n\n
\n
\n
\n
\n

Classroom Considerations

\n
Best For: Explaining a topic
Video is ad-free
\n
\n
\n

Educator Ratings

\n
\n
\n
\n
\n
\n\nShow resource details\n
\n
\n\" data-title=\"Get Full Access\" data-container=\"body\" rel=\"popover\" tabindex=\"0\" aria-label=\"Play video: Master SQL for Data Analysis - Sequential Numbers\" href=\"/subscription/new\">\"Master\n\n
\n
\n
\n\n\n\n"}