SQL Window Function How to write SQL Query using RANK, DENSE RANK, LEAD/LAG SQL Queries Tutorial

Channel Avatar
Comment
X
Share
SQL Window Function How to write SQL Query using RANK, DENSE RANK, LEAD/LAG SQL Queries Tutorial
SQL Window Function How to write SQL Query using RANK, DENSE RANK, LEAD/LAG 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 or analytic functions. We go through the syntax of using rank, dense_rank, row_number, lead, lag and max functions as window function.

Over clause is explained in detail in this video. Over clause is used in SQL when we need to use window function. Inside Over clause, we also use Partition By clause and also Order by clause.
Partition By clause is used to specify the column based on which different windows needs to be created.

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.

Download all scripts and Queries used in this video from below link:
https://techtfq.com/video/sql-window-function-part1-sql-queries-tutorial
Click on the /”Download SQL Script/” button to download scripts.

Timestamp:
00:00 Intro

01:33 Understanding Aggregate function
03:16 Syntax to write SQL Query using Window Function
06:33 ROW_NUMBER() Window Function in SQL
11:57 RANK() Window Function in SQL
15:43 DENSE_RANK() Window Function in SQL
17:10 Difference between RANK, DENSE RANK and ROW NUMBER in SQL
17:59 LEAD() and LAG() Window Function in SQL

I hope this video was helpful and gives you a good understanding of how to write SQL Queries using window functions or analytic functions. If you liked what you saw, then please make sure to like, subscribe and comment any feedback you may have.
Also please do not hesitate to share the video with your friends and colleagues who may be interested in learning SQL

WATCH MORE VIDEOS HERE

SQL Tutorial – Basic concepts:
https://www.youtube.com/playlist?listPLavw5C92dz9HQQ_COgGb7kf_1H8UWUBxO

SQL Tutorial – Intermediate concepts:
https://www.youtube.com/playlist?listPLavw5C92dz9FD9XspliRM_HZM_jK7tkii

SQL Tutorial – Advance concepts:
https://www.youtube.com/playlist?listPLavw5C92dz9GbmgiW4TWVnxhjMFOIf0Q7

Practice Solving Basic SQL Queries:
https://www.youtube.com/playlist?listPLavw5C92dz9F66P3GFo5O6nJ4DfZNhVsp

Practice Solving Intermediate SQL Queries:
https://www.youtube.com/playlist?listPLavw5C92dz9EIYmNXJ8ZtQ1bmLIpt0SpV

Practice Solving Complex SQL Queries:
https://www.youtube.com/playlist?listPLavw5C92dz9Fahr7taauUx5RnTfuGyL–

Data Analytics Career guidance:
https://www.youtube.com/playlist?listPLavw5C92dz9FDsr995DjwCy9XNaIukb8P

SQL Course, SQL Training Platform Recommendations:
https://www.youtube.com/playlist?listPLavw5C92dz9GqF1Q_zn8KnYvFgtEOh-2n

Python Tutorial:
https://www.youtube.com/playlist?listPLavw5C92dz9FePZXIo4jpsupqp3X0w2SW

Git and GitHub Tutorial:
https://www.youtube.com/playlist?listPLavw5C92dz9EI1MPlqqDpe3bgr8RJZE0b

Data Analytics Projects:
https://www.youtube.com/playlist?listPLavw5C92dz9HwT_uStsDdJbuBOt_XD0ch

THANK YOU,
Thoufiq

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Keywords: SQL Window Function, SQL Window Functions, Window Function in SQL, SQL Analytic Function, Analytic Function, Window Function, How to write SQL Queries, RANK, DENSE_RANK, LEAD, LAG, ROW_NUMBER, PARTITION BY, OVER clause, SQL OVER Clause, SQL Partition By, Parition by query, rank function in sql, rank function, dense rank function, lead function, lag function, row number in sql, SQL query tutorial, sql queries tutorial, sql tutorial, tutorial, sql query writing tutorial

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *