#10. Window Functions in SQL (Aggregate Window Functions)
In today's lesson, we'll begin exploring an interesting and useful topic in SQL: window functions.
Video timestamps:
00:00 Start
00:07 Definition of window functions and how they differ from standard aggregation functions
00:54 Example of a window aggregation function (calculating maximum salaries in departments)
01:45 Main components of a window function
03:14 Sorting in a window function
04:16 Example of a window aggregation function (calculating the percentage of employee salaries from the sum of all department salaries)
05:54 Conclusion
The SQL commands mentioned in the video are available at: https://pastebin.com/S7w2YEFF
Suggest a new topic for the video: https://vdsr7ufo2in.typeform.com/to/H...
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Also, a reminder. This course includes a Telegram group where I answer all participant questions online and provide assistance throughout the course.
Join the group freely via the invitation link (provided below). There is currently no limit on the number of participants.
Ask any questions you may have about our training in this group. Watch the video and try to replicate it. It worked perfectly. If something doesn't work, post your question in the group. I'll answer everyone and help.
Link to the Telegram group: https://t.me/joinchat/LlHDMBmN0SAxM5_...
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
★ Dear friends! If you like what I do and would like to support the project financially, please visit: https://www.donationalerts.com/r/exce...
★ Let's be friends:
Facebook | / excelstore.pro
VKontakte | https://vk.com/ExcelStore
Telegram | https://t.me/ExcelStore
#SQLTraining #SQLCourses #SQLLessons #CookMaxim #ExcelStore
Auf dieser Seite können Sie das Online-Video #10. Window Functions in SQL (Aggregate Window Functions) mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Maxim Kukhar [Learning Excel, VBA, SQL] 28 April 2021 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 47,599 Mal angesehen und es wurde von 1.6 tausend den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
