SQL Window Function - Part #1 | SQL Queries Tutorial

This video is about Window Functions in SQL which is also referred to as Analytic Function in some of the RDBMS. SQL Window Functions covered in this video are RANK, DENSE RANK, ROW NUMBER, LEAD, LAG. Also, we see how to use SQL Aggregate functions like MIN, MAX, SUM, COUNT, AVG as window function.

This video is focused on teaching how to write SQL Queries using different window functions. We go through the syntax of writing SQL Queries using window functions. We shall cover Over clause and Partition By clause.

The window function you learn in this video is applicable to any RDBMS since these functions are commonly used across most of the popular RDBMS such as Oracle, MySQL, PostgreSQL, Microsoft SQL Server etc.

You can download all the SQL Query Scripts, table structure and table data used in this video from the link below: