#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
In questa pagina del sito puoi guardare il video online #10. Window Functions in SQL (Aggregate Window Functions) della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Maxim Kukhar [Learning Excel, VBA, SQL] 28 aprile 2021, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 47,599 volte e gli è piaciuto 1.6 mille spettatori. Buona visione!
