SQL Window Function - Part #2 | SQL Queries Tutorial

SQL
Written By Thoufiq Mohammed

This is the second video in the series of SQL Window Functions. The window functions covered in this video are FIRST_VALUE, LAST_VALUE, NTH_VALUE, NTILE, CUME_DIST and PERCENT_RANK. We also cover Frame Clause and an alternate way to write SQL Queries using Window clause.

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.

The video is posted on my YouTube channel techTFQ. Link to the video below:

Click on the below link to download all the SQL Query script and the table creation script used in this video.

Thoufiq Mohammed https://techtfq.com
Previous

Learn how to write SQL Queries(Practice Complex SQL Queries)
Next

SQL Window Function - Part #1 | SQL Queries Tutorial