Тёмный

Working with SQL NULL values | Null Handling Functions 

Ankit Bansal
Подписаться 121 тыс.
Просмотров 22 тыс.
50% 1

In this video we will be talking about SQL NULL values. Following aspects will be covered :
1- How to filter null values
2- How to handle null values
3- ISNULL and COALESCE functions
4- How aggregate functions handle nulls
5- how to insert nulls into a table.

Опубликовано:

 

26 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 37   
@denizcantasdelen9755
@denizcantasdelen9755 2 года назад
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
@ankitbansal6 2 года назад
Thank you 😊
@Divyasversion
@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
@ankitbansal6 Месяц назад
Better late than never 😊
@tupaiadhikari
@tupaiadhikari 2 года назад
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
@ankitbansal6 2 года назад
Thank you so much 💗
@pradeep09ca04
@pradeep09ca04 2 года назад
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
@ankitbansal6 2 года назад
Thank you 😊
@lokeshvaishnav218
@lokeshvaishnav218 Год назад
Your videos are amazing 🤩 , Extremely sleek and explanation is very clear
@ankitbansal6
@ankitbansal6 Год назад
Happy to hear that!
@kanchankumar3355
@kanchankumar3355 2 года назад
Helpful, thanks for putting it up !!
@ankitbansal6
@ankitbansal6 2 года назад
Glad it was helpful!
@deeptidogra7948
@deeptidogra7948 Год назад
Very Informative ..Thanks
@ankitbansal6
@ankitbansal6 Год назад
Glad it was helpful!
@nipunshetty9640
@nipunshetty9640 Год назад
How to handle null values if it's present in 1 million number of records of data?.
@guddu11000
@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
@mahesh6701
@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
@ankitbansal6 Год назад
Sure
@priyankas-ov6kk
@priyankas-ov6kk Год назад
Thank you for this video. Supreb
@ankitbansal6
@ankitbansal6 Год назад
You are welcome
@agrim8863
@agrim8863 2 года назад
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
@ankitbansal6 2 года назад
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.
@abhishek_grd
@abhishek_grd 2 года назад
Thanks !!
@gobindaroy7811
@gobindaroy7811 Год назад
amazing explanation Sir
@ankitbansal6
@ankitbansal6 Год назад
Keep watching
@parthchadha9676
@parthchadha9676 11 месяцев назад
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
@mayurkanth6987 4 месяца назад
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
@djjiang3718
@djjiang3718 Год назад
Thank you and good share!
@ankitbansal6
@ankitbansal6 Год назад
Glad you enjoyed it
@nihal2725
@nihal2725 2 года назад
good stuff
@prabhavpushkar3869
@prabhavpushkar3869 Год назад
will these expressions be same for oracle pl/sql or specifically only for t-sql
@ankitbansal6
@ankitbansal6 Год назад
Yes
@hanson4christ496
@hanson4christ496 Год назад
When I use ISNULL(salary,0) It's not passing the value 0 to my empty fields 😊
@praveenbhandari2516
@praveenbhandari2516 Год назад
The content is too good but there is a lot of background noise also in between the video
@ankitbansal6
@ankitbansal6 Год назад
Sorry about it. Only in a few videos that is the case. Most others are good.
@praveenbhandari2516
@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
@Subo64
@Subo64 Год назад
Toomuch background noise
Далее