In this tutorial, we write a SQL Query to forward fill values for NULL records. This is also known as the Last Not NULL puzzle.
We make use of Windows function FIRST_VALUE. We also write the query using MAX function.
This is a FAANG interview query.
The practice data and SQL Queries are available here-
[ Ссылка ]
Difference between Count(*), Count(1) and Count(column)
[ Ссылка ]
How to install SQL Server for practice?
[ Ссылка ]
Check out the complete list of SQL Query Interview Questions -
[ Ссылка ]
Best Data Science / Analytics / SQL courses
Learn SQL Basics for Data Science Specialization
[ Ссылка ]
Data Science Fundamentals with Python and SQL Specialization
[ Ссылка ]
Beginners to Python Programming
[ Ссылка ]
Data Science and Business Analytics with Python
[ Ссылка ]
Get 40% OFF of Skillshare with code FLASH40 - October 2022
[ Ссылка ]
Python for Everybody Specialization
[ Ссылка ]
Google Data Analytics Professional Certificate
[ Ссылка ]
Coursera Plus - Data Science Career Skills
[ Ссылка ]
Please do not forget to like, subscribe and share.
For enrolling and enquiries, please contact us at
Website - [ Ссылка ]
Instagram - [ Ссылка ]
Facebook - [ Ссылка ]
Linkedin - [ Ссылка ]
Email - learn@knowstar.org
![](https://i.ytimg.com/vi/4MH8iRnhPO0/mqdefault.jpg)