SQL Window Function. How to write SQL Query using Frame Clause, CUME_DIST. 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 FIRST_VALUE, LAST_VALUE, NTH_VALUE, NTILE, CUME_DIST and PERCENT_RANK. Also we cover how to use FRAME Clause while writing SQL Queries using window function. We also look at alternate way of writing SQL Query using window function.

We discuss in detail about the Frame clause and how RANGE is different from ROWS and how to use Unbounded Preceding and Unbounded Following while using certain window functions.

This is the second video where we talk about window functions in SQL. I have made another video covering other window functions such as RANK, DENSE RANK, LEAD, LAG and ROW NUMBER. Link to the previous video is mentioned below:
   • SQL Window Function | How to write SQ...  

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 first value, last value, frame clause, nth value. ntile, cume dist and percent rank as window function in SQL query.

We look at how to use WINDOW clause while writing SQL query using window functions. We talk about the OVER clause and how partition by clause can impact the result set.

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 the SQL Queries, Table Structure and Table data used in this video ***/
Link: https://techtfq.com/blog/sql-window-f...
On this page, Click on the button which says "Download SQL Script" to download the .sql file (.sql file can be opened in any text editor)

Timestamp:
00:00 Intro
02:12 FIRST_VALUE
07:25 LAST_VALUE
10:25 Frame Clause
22:26 Alternate way of writing SQL Query using window function using Window clause
26:41 NTH_VALUE
31:47 NTILE
38:02 CUME_DIST
47:35 PERCENT_RANK

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:
   • SQL Tutorial - Basic concepts  

✅ SQL Tutorial - Intermediate concepts:
   • SQL Tutorial - Intermediate concepts  

✅ SQL Tutorial - Advance concepts:
   • SQL Tutorial - Advance concepts  

✅ Practice Solving Basic SQL Queries:
   • Practice Solving BASIC SQL Queries  

✅ Practice Solving Intermediate SQL Queries:
   • Practice Solving INTERMEDIATE SQL Que...  

✅ Practice Solving Complex SQL Queries:
   • Practice Solving COMPLEX SQL Queries  

✅ Data Analytics Career guidance:
   • Data Analytics career and more  

✅ SQL Course, SQL Training Platform Recommendations:
   • SQL Course / Training  

✅ Python Tutorial:
   • Python Tutorial  

✅ Git and GitHub Tutorial:
   • Git and GitHub  

✅ Data Analytics Projects:
   • Data Analytics Projects  

THANK YOU,
Thoufiq