LAG and LEAD Functions in SQL Server

Home/Development, SQL Server/LAG and LEAD Functions in SQL Server

LAG and LEAD Functions in SQL Server

$15.00 $4.00

In Transact-SQL (T-SQL) 2012 LAG & LEAD are the new analytical functions. LAG access data from the previous row in the same result set without the use of self-join. LEAD access data from a subsequent row in the same result set without the use of self-join. This lab is divided into four exercises explaining LEAD and LAG functions such as compare values with in partitions using LAG & LEAD, difference within partitions using LAG & LEAD.

Exercise 1: compare values within partitions using LAG & LEAD
Exercise 2: Difference within partitions using LAG & LEAD
Exercise 3: Self-Assessment
Exercise 4: T-SQL Challenge

Categories: ,

Description

In Transact-SQL (T-SQL) 2012 LAG & LEAD are the new analytical functions. LAG access data from the previous row in the same result set without the use of self-join. LEAD access data from a subsequent row in the same result set without the use of self-join. This lab is divided into four exercises explaining LEAD and LAG functions such as compare values with in partitions using LAG & LEAD, difference within partitions using LAG & LEAD.

Exercise 1: compare values within partitions using LAG & LEAD
Exercise 2: Difference within partitions using LAG & LEAD
Exercise 3: Self-Assessment
Exercise 4: T-SQL Challenge

Data Platform Virtual Summit 2020

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin.

SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.