SQL Value Window Functions | LEAD, LAG, FIRST_VALUE, LAST_VALUE |

Опубликовано: 17 Март 2026
на канале: Data with Baraa

51,444

1.7k

Visually explained how SQL value window functions like LEAD, LAG, FIRST_VALUE, and LAST_VALUE compare data across rows.
👉 Subscribe, Like, and Comment If you want more FREE Courses ❤️   / @datawithbaraa

━━━━━

MY COURSES
To get certified, better clean structure & progress, support me:
🏅SQL https://www.datawithbaraa.com/course/...
🏅Tableau https://www.datawithbaraa.com/course/...
🏅Udemy SQL: https://bit.ly/4hH947P
🏅Udemy Tableau: https://bit.ly/3xFiDDk

━━━━━

CONNECT WITH ME
📬 Newsletter https://www.blog.datawithbaraa.com/su...
👨‍💻 LinkedIn   / baraa-khatib-salkini
📸 Instagram   / datawithbaraa
🎥 TikTok   / datawithbaraa
🌍 Website https://www.datawithbaraa.com/
💬 Discord   / discord
🧭 Notion Roadmaps https://www.notion.com/@datawithbaraa
⭐ Favorite Books/Gear https://candle-gosling-511.notion.sit...
📩 Sponsorships [email protected]

━━━━━

Get 25% OFF DataCamp's Here
https://www.datacamp.com/coupon/membe...

━━━━━

MY FREE COURSES
SQL    • SQL Full Course for Beginners (30 Hours) –...
Python    • Python Ultimate Course
Tableau    • Complete HR Tableau Project End-to-End | L...
Real World Data Projects    • Data Analyst Portfolio Projects
Data Career Roadmaps    • Data Career Roadmaps

━━━━━

🎁 FREE DOWNLOADS & MATERIALS
https://www.datawithbaraa.com/wiki/sq...

📖 Table of Content
00:00 Intro
00:00:33 What are Window Value Functions?
00:04:12 MIN & MAX
00:14:01 MIN & MAX: Month-Over-Month Analysis
00:20:50 MIN & MAX: Customer Retention Analysis
00:29:36 FIRST_VALUE & LAST_VALUE
00:19:45 ROW_NUMBER: TOP-N Analysis
00:41:46 Summary

This course is perfect for data analysts, data engineers, data scientists, software developers, and students—covering everything from the basics to advanced SQL topics.
#sql #sqlserver #data #analytics #dataanalysis #datascience