This Repository contains SQL queries written using Window Functions. This is part of a course from Vertabelo Academy to gain deeper understanding on how window functions work, and when and how to use them. This tutorial in SQL starts at a very basic level and goes up to advanced querying just by using window functions.
All the queries are stored in different folders shown below. These folders are created based on the different window functions available and their uses.
The database for all the topics are stored in one excel file named "Database.xlsx".
- Introduction
- OVER()
- OVER(Partition By)
- Ranking Functions
- Window Frame
- Analytic Functions
- Partition By, Order By
- Evaluation Order
- Practice Field