filmov
tv
SQL Tutorial - Window Functions - Lag and Lead
Показать описание
Another video brought to you by BeardedDev, bringing you tutorials on Business Intelligence, SQL Programming and Data Analysis.
In this video I talk about using Lag and Lead in Windows Functions.
T-SQL Querying
T-SQL Fundamentals
Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions
This video covers the requirements to pass the exam:
If you would like to follow along with the tutorial please run the SQL below:
IF OBJECT_ID(N'dbo.Sales', N'U') IS NOT NULL
DROP TABLE dbo.Sales;
GO
CREATE TABLE dbo.Sales
(
Sales_Id INT NOT NULL IDENTITY(1, 1)
CONSTRAINT PK_Sales_Sales_Id PRIMARY KEY
, Sales_Customer_Id INT NOT NULL
, Sales_Date DATETIME2 NOT NULL
, Sales_Amount DECIMAL (16, 2) NOT NULL
)
INSERT INTO dbo.Sales (Sales_Customer_Id, Sales_Date, Sales_Amount)
VALUES
(1, '20180102', 54.99)
, (1, '20180103', 72.99)
, (1, '20180104', 34.99)
, (1, '20180115', 29.99)
, (1, '20180121', 67.00)
Lag and Lead are useful for performing trend analysis, in the example I show how we can display a customer spending trend.
Lag will show the previous value.
Lead will show the next value.
Lag and Lead accept multiple parameters as demonstrated in the video:
LAG([Column], [Offset], [Value if NULL])
The example of LAG and LEAD in the video can be shown by executing the below SQL query:
SELECT
Sales_Customer_Id
, Sales_Date
, LAG(Sales_Amount, 2, 0) OVER(PARTITION BY Sales_Customer_Id ORDER BY Sales_Date) AS PrevValue
, Sales_Amount
, LEAD(Sales_Amount, 2, 0) OVER(PARTITION BY Sales_Customer_Id ORDER BY Sales_Date) AS NextValue
FROM dbo.Sales
Please feel free to post comments.
In this video I talk about using Lag and Lead in Windows Functions.
T-SQL Querying
T-SQL Fundamentals
Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions
This video covers the requirements to pass the exam:
If you would like to follow along with the tutorial please run the SQL below:
IF OBJECT_ID(N'dbo.Sales', N'U') IS NOT NULL
DROP TABLE dbo.Sales;
GO
CREATE TABLE dbo.Sales
(
Sales_Id INT NOT NULL IDENTITY(1, 1)
CONSTRAINT PK_Sales_Sales_Id PRIMARY KEY
, Sales_Customer_Id INT NOT NULL
, Sales_Date DATETIME2 NOT NULL
, Sales_Amount DECIMAL (16, 2) NOT NULL
)
INSERT INTO dbo.Sales (Sales_Customer_Id, Sales_Date, Sales_Amount)
VALUES
(1, '20180102', 54.99)
, (1, '20180103', 72.99)
, (1, '20180104', 34.99)
, (1, '20180115', 29.99)
, (1, '20180121', 67.00)
Lag and Lead are useful for performing trend analysis, in the example I show how we can display a customer spending trend.
Lag will show the previous value.
Lead will show the next value.
Lag and Lead accept multiple parameters as demonstrated in the video:
LAG([Column], [Offset], [Value if NULL])
The example of LAG and LEAD in the video can be shown by executing the below SQL query:
SELECT
Sales_Customer_Id
, Sales_Date
, LAG(Sales_Amount, 2, 0) OVER(PARTITION BY Sales_Customer_Id ORDER BY Sales_Date) AS PrevValue
, Sales_Amount
, LEAD(Sales_Amount, 2, 0) OVER(PARTITION BY Sales_Customer_Id ORDER BY Sales_Date) AS NextValue
FROM dbo.Sales
Please feel free to post comments.
0:07:52
SQL Window Functions | Clearly Explained | PARTITION BY, ORDER BY, ROW_NUMBER, RANK, DENSE_RANK
0:10:13
SQL Window Functions in 10 Minutes
0:24:55
SQL Window Function | How to write SQL Query using RANK, DENSE RANK, LEAD/LAG | SQL Queries Tutorial
0:11:07
SQL Window Functions Tutorial | Window Functions in SQL
0:57:19
SQL Window Functions Basics | Partition By, Order By, Frame | #SQL Course 22
3:51:23
The Ultimate SQL Window Functions Course | Complete End-to-End Guide
0:09:11
SQL Window Functions: Explained (with examples)
0:13:29
Window Functions in MySQL | Intermediate MySQL
0:19:34
Top 10 SQL Interview Questions from MorganStanley | Data Engineering Interview
0:21:21
SQL Window Function with Example- RANK, DENSE RANK, ROW NUMBER, LEAD/LAG | SQL Tutorial in Hindi 14
0:12:41
SQL Tutorial - Window Functions
0:00:58
Data Analyst SQL Interview Question | Window Functions | Moving Average #sqlinterview #dataanalysis
0:11:00
Window functions in SQL Server
0:23:16
SQL Tutorial - Window Functions (Follow Along)
0:06:01
SQL Window Functions for Beginners
0:00:33
5 Best SQL Websites to Practice n Learn Interview Questions for FREE
1:40:05
Session 36 - Window Functions in SQL | DSMP 2023
0:00:41
SQL | RANK Vs DENSE_RANK #sqltips #sqlserver
0:54:31
SQL Window Function | How to write SQL Query using Frame Clause, CUME_DIST | SQL Queries Tutorial
0:00:37
SQL | Windows Vs Aggregate Functions
0:39:19
SQL Intermediário - Window Functions
0:00:18
SQL Tricks | You Must Try This ! Windows Functions
0:04:14
Intermediate SQL Tutorial | Partition By
0:04:13
Window Functions in SQL - Performing Calculations across Rows
Комментарии