📝 Get my free SQL Cheat Sheets: [ Ссылка ]
🎓 Learn and become confident in SQL: [ Ссылка ]
Window functions in SQL are a very helpful feature if you want to perform calculations on your data.
But they can be a little tricky to understand.
In this video, you’ll learn what a window function is, why you would use one, and see a couple of examples on an SQL database.
This functionality is available in Oracle, SQL Server, MySQL, and Postgres.
Timestamps:
00:00 What is a window function?
00:47 The sample data and running total
01:39 Window function syntax explained
02:45 Demo of SQL with a running total
05:22 The partition concept
06:25 Adding a “partition by” clause to our query
08:02 Other scenarios for window functions
Links:
My GitHub repository with my SQL scripts: [ Ссылка ]
The SQL script used for this video: [ Ссылка ]
Article: SQL Window Functions: [ Ссылка ]
Ещё видео!