Supercharge Your SQL Skills with Lead & Lag Functions

preview_player
Показать описание
Be a super hero and learn to LEAD (and LAG) in SQL. I start out showing you the problem statement in #Excel and then we take it over to SQL Server to script common table expressions using window functions in order to solve a business question on time intervals.
#sqlserver #analytics #tsql #groupby #dataanalyst #data

0:00 INTRO
1:08 DATA OVERVIEW IN EXCEL
4:15 GET STRAIGHT TO THE POINT: LAG FUNCTION
4:38 MIGOS
6:09 RESULTS WITH PARTITION BY
6:09 RESULTS WITHOUT PARTITION BY
8:52 LEAD FUNCTION
9:57 BONUS CONTENT: SQL SCRIPT USING CTEs

Learn GROUP BY vs PARTITION BY in SQL

★☆★ FOLLOW ME BELOW: ★☆★

☕☕ If my channel has helped you, consider buying me a coffee! Thanks & Cheers! ☕☕

★☆★ Support this Channel: ★☆★

#Excel #SQLServer #analytics #data #dataanalyst #education #onlinelearning
  1. Anthony Smoak
  2. CTE
  3. Common Table Expression
  4. Excel
  5. Lag
  6. Lead
Рекомендации по теме
Supercharge Your SQL 0:16:37

Supercharge Your SQL Skills with Lead & Lag Functions

Supercharge Your T-sql 0:33:27

Supercharge Your T-sql Skills With Variables!

Part 23 | 0:04:15

Part 23 | Supercharge Your SQL Skills with Subquery : Step-by-Step Tutorial

Supercharge Your Data 0:00:31

Supercharge Your Data Skills with SQL!#SQL #DatabaseManagement #LearnSQL #Youtubeshorts #viral.

Master SQL (Week 1:51:16

Master SQL (Week 4 Practical): Hands-On Joins to Supercharge Your Database Skills!

Supercharge Your SQL 0:00:32

Supercharge Your SQL Queries with Indexes!

AI2sql: Supercharge Your 0:03:56

AI2sql: Supercharge Your Data Analysis with Instant SQL Queries

You Can Do 0:17:23

You Can Do It in SQL

AI Tools That 0:09:40

AI Tools That SUPERCHARGE Your Boolean Searches for Hiring! | PART 2

Supercharge Your Queries 0:12:50

Supercharge Your Queries - Indexes in T-SQL

SQL Tips to 0:35:21

SQL Tips to Supercharge Your Data Exploration

From Query Plan 1:02:35

From Query Plan to Performance: Supercharging your Apache Spark Queries using the Spark UI SQL Tab

Sneaky Trick to 0:00:47

Sneaky Trick to Supercharge Productivity Real Deadlines Real Results

3 Essential SQL 0:08:12

3 Essential SQL Functions to Supercharge Your Queries (Limit, Max, Min)

Supercharge Your Data 0:14:05

Supercharge Your Data Filtering Skills Now using Multiple Data Filters and enhancing data retrieval.

L1 1 0:22:20

L1 1 11'Supercharge SQL Queries: Master LIKE, NOT LIKE, & Regular Expressions! ✨🔍'...

#Ways to Increase 0:00:58

#Ways to Increase Efficiency with SQL WHERE Clause: Supercharge Your Queries! #shorts #sql #where

DataFusion and Arrow: 0:29:18

DataFusion and Arrow: Supercharge Your Data Analytical Tool with a Rusty Query Engine

5 Ways to 0:01:01

5 Ways to Supercharge Your Data Analysis Skills | Career in Data Science | Ziyaad | #datascience

Supercharge app dev 0:06:24

Supercharge app dev with generative AI in under 7 minutes

🗄️ Supercharge Your 0:03:55

🗄️ Supercharge Your Data Retrieval: Mastering Database Indexing Techniques!

Supercharge Your Data 0:17:25

Supercharge Your Data Warehouse: Introducing Python Stored Procedures

Synapse Espresso: How 0:04:56

Synapse Espresso: How Serverless SQL Pools supercharge your CSV files?

#Supercharge Your Data 0:00:58

#Supercharge Your Data Skills with Hadoop: Unleashing the Power of Hadoop!

Комментарии
Автор

Great video! Enjoyed watching you use of Excel formulas to help code and validate the LAG(), LEAD() and AVG() functions using SQL. Thanks Anthony!

uc
Автор

Hello, I’m wondering if you have or can do a tutorial on creating a parameter table such as start datetime & end datetime and how to incorporate this so a user can input the date and use it to refresh the table being pulled from a database?

ifortniteclipz