Replacing NULL Values | SQL Intermediate Level Question
Namastey All,
Welcome to Select Star. Today I am solving a medium level interview question.
We have been provided a table shop and we are required to replace NULL Values in it with last non null value.
Topics covered :
1. Window Function SUM (RUNNING SUM)
2. Requirement of PRIMARY KEY
3. CASE WHEN inside SUM
4. SELF JOIN
Related Playlists:
1. Basic SQL Course :
• Basic SQL Course
2. SQL Easy Interview Questions :
• SQL Easy Interview Question
3. SQL Mediun to Hard Level Interview Questions :
• SQL Intermediate to Advanced Interview Que...
If you want me to solve some specific questions, then email me :
ananttnegii@gmail.com
Script for table creation :
create table shop (product varchar(50));
insert into shop values ('Table'),(null),(null),('Chair'),(null),('Sofa'),(null),(null),(null),(null);
select * from shop;
Happy Querying
#sql #data #dataanalytics #dataanalyst #analysis #analyst #dataengineers #dataengineering #machinelearning #datascience #datascientist #machinelearningengineer #businessanalyst #businessanalyticsjobs #businessanalytics #sqlserver #sqltips #sqlforbeginners #postgres #postgresql #mssqlserver #mssql #oracle #mysql #mysqltutorials #database #databasedesign #databasemanagement
On this page of the site you can watch the video online Replacing NULL Values | SQL Intermediate Level Question with a duration of hours minute second in good quality, which was uploaded by the user Select Star 07 August 2024, share the link with friends and acquaintances, this video has already been watched 786 times on youtube and it was liked by 33 viewers. Enjoy your viewing!
