SQL Interview Question: Fill NULL with Last Non-NULL Value | Oracle SQL Explained
In this video, we solve a popular SQL interview question:
👉 How to fill NULL values with the last non-NULL value in Oracle SQL?
We walk through multiple solutions step by step:
✅ Using LAST_VALUE … IGNORE NULLS
✅ Using MAX() OVER window function
✅ Using Correlated Subquery
✅ Bonus: Recursive CTE approach
This is a must-know concept for anyone preparing for SQL interviews or working with real-world database problems.
💡 If you know another approach, share it in the comments so we can learn and grow together!
And if you find any mistakes, please correct me — we’re all here to learn 🙌
If you’re preparing for SQL / Database Developer / Data Analyst / Data Science / Data Engineer job interviews, don’t forget to:
👍 Like this video
💬 Comment your thoughts
🔔 Subscribe for more SQL interview questions with solutions
#SQLInterview #OracleSQL #DataEngineer #DataAnalyst #DatabaseDeveloper #SQLTutorial #JobInterviewPrep #learnsql #datascientist #plsql #sqltips #sqlinterviewquestionsandanswers
On this page of the site you can watch the video online SQL Interview Question: Fill NULL with Last Non-NULL Value | Oracle SQL Explained with a duration of hours minute second in good quality, which was uploaded by the user The Cre8tive Minds Lab 01 January 1970, share the link with friends and acquaintances, this video has already been watched 39 times on youtube and it was liked by 2 viewers. Enjoy your viewing!
