#13. Window Functions in SQL (Window Function Boundaries)
In the previous video, we discussed analytical window functions. Today, we'll continue the topic of window functions and discuss an important and useful parameter: window boundaries.
Video timestamps:
00:00 Start
00:16 Description of ROWS and RANGE instructions
02:39 UNBOUNDED PRECEDING instruction
03:32 UNBOUNDED FOLLOWING instruction
04:07 "Numeric Value" PRECEDING instruction
04:58 "Numeric Value" FOLLOWING instruction
06:43 BETWEEN instruction (using INTERVAL)
09:25 Comparison of ROWS and RANGE
11:02 Default value for ORDER BY
11:52 Conclusion
The SQL commands mentioned in the video are available at: https://pastebin.com/bD7xEZDN
Suggest a new topic for the video: https://vdsr7ufo2in.typeform.com/to/H...
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Also, a reminder. This course has a Telegram group where I answer all participants' questions online and help them along the way.
Join the group is free, just click the invite link (below). There is currently no limit on the number of participants.
Ask any questions you may have in this group, as part of our training. 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 want to support the project financially, here's the link: 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