Working with SQL NULL values | Null Handling Functions

[@denizcantasdelen9755]

It is a tradition on youtube that many channels do not get number of subscribers and views that they actually deserve. Your sql videos are among the best ones in terms of their quality and hardness

[@ankitbansal6]

Thank you 😊

[@tupaiadhikari]

On this auspicious event of Teachers Day, I would like to wish you Happy Teachers Day. Your Videos are invaluable and thanks to your You Tube channel, that many like me are feeling confident with SQL since the last 3-4 months.

[@ankitbansal6]

Thank you so much 💗

[@Divyasversion]

Where was this channel in my whole life now I can say I wish I would have found this channel earlier Thanku for making videos 😢❤

[@ankitbansal6]

Better late than never 😊

[@pradeep09ca04]

Yours Video, Certainly attracts the audience 👍as well as proven to be the KEY to understand the conecpts from "0 to strong exception" handilng data, to helped many of Data Professionals like me. Thanks for putting efforts to create this Video

[@ankitbansal6]

Thank you 😊

[@lokeshvaishnav218]

Your videos are amazing 🤩 , Extremely sleek and explanation is very clear

[@ankitbansal6]

Happy to hear that!

[@kanchankumar3355]

Helpful, thanks for putting it up !!

[@ankitbansal6]

Glad it was helpful!

[@mahesh6701]

Ankit, could you please put a video on Index, Cluster index and Non-Cluster Index with real time example questions for better understanding. Thanks.

[@ankitbansal6]

Sure

[@deeptidogra7948]

Very Informative ..Thanks

[@ankitbansal6]

Glad it was helpful!

[@gobindaroy7811]

amazing explanation Sir

[@ankitbansal6]

Keep watching

[@guddu11000]

Hello Ankit jee, i have scenerio that i have forex data table where i have some missing dates in a week and missing data for complete whole week in a month. I want to find all the missing dates in fact table and generate the data and fill the data from previous filled value. how can i achive

[@parthchadha9676]

Hello ankit, I tried adding more rows will null values in them and then run the coalesce function but is returns only the first value in all 3 nulls instead of different values. Am I understanding it wrong? Here is my code : Select *, isnull(age,8), coalesce(age,9,10) from customer

[@mayurkanth6987]

Of course it will show the first value provided first value should be NOT NULL. Put First value as NULL and then see it will return 2nd value in coalesce

[@priyankas-ov6kk]

Thank you for this video. Supreb

[@ankitbansal6]

You are welcome

[@agrim8863]

Hi, I have been following your videos for quite a long time. Need some advice from you I come from a non IT background thus a novice programmer want to get into field of data analytics and data science. Please guide me.

[@ankitbansal6]

You can start learning basics of SQL and Excel first. Once you are comfortable with basics practice questions from my channel. Later you can learn one BI tool like tableau or power BI.

[@prabhavpushkar3869]

will these expressions be same for oracle pl/sql or specifically only for t-sql

[@ankitbansal6]

Yes

[@nipunshetty9640]

How to handle null values if it's present in 1 million number of records of data?.

[@djjiang3718]

Thank you and good share!

[@ankitbansal6]

Glad you enjoyed it

[@abhishek_grd]

Thanks !!

[@hanson4christ496]

When I use ISNULL(salary,0) It's not passing the value 0 to my empty fields 😊

[@nihal2725]

good stuff

[@Subo64]

Toomuch background noise

[@praveenbhandari2516]

The content is too good but there is a lot of background noise also in between the video

[@ankitbansal6]

Sorry about it. Only in a few videos that is the case. Most others are good.

[@praveenbhandari2516]

@@ankitbansal6 yeah no worries but your video is totally worth for me and it's incredible they way to teach. Please upload this kind of video .I have a request if you will make a video data analyst to data engineering how we can change the job