LAG and LEAD Functions (SQL) - Accessing Data in Other Rows

preview_player
Показать описание
In SQL, we can use the LAG and LEAD functions to access data in previous or subsequent rows. LAG is for previous rows, and LEAD is for subsequent rows.
Рекомендации по теме
Комментарии
Автор

Best explanation for a beginner simple and easy to understand

glenrietveld
Автор

You made it so simple to understand. Awesome job!

SistaSueK
Автор

Fantastic video … simple, and very clear.

Winchester_
Автор

absolutely stunning and clarifying video

vishnusunil
Автор

Didnt k ow about the offset option. Ty!

johnvak
Автор

thanks a lot! this helped refresh my memory

DataAnalytics
Автор

Shouldn't it be the AS next day in the LEAD part? 1:53

pashtun-travels-uk