How NULL values work in SQL queries | SQL Interview Question

preview_player
Показать описание

============

============
The camera gear I use in my Videos

============
Connect With Me on My Social Media

============
FAQ
Which book to refer to learn -

============
AFFILIATE DISCLOSURE:
#rebellionrider

=============
In this SQL interview question breakdown, we dive into the intriguing world of NULL values. 🤔 Ever wondered what happens when you compare NULL to another NULL? 🤷‍♂️ I explore the unexpected behavior, clarify the logic, and reveal why NULL doesn’t play by the usual rules. Whether you’re a seasoned SQL pro or just starting out, this video sheds light on a fundamental concept that can trip up even the most experienced programmers. 🚀

🎯 Key Takeaways:

Learn why NULL represents the “unknown” or “missing” value.
Discover the ternary logic behind NULL comparisons (True, False, and Unknown).
Uncover the best practices for handling NULLs in your SQL queries.
Get ready to impress in your next technical interview! 💡
👍 If you found this video helpful, don’t forget to hit the like button and subscribe for more SQL tips and tricks! 📺🔔"
  1. Manish Sharma
  2. SQL
  3. CASE WHEN
  4. Interview Question
  5. Database
  6. SQL NULL comparison
Рекомендации по теме
SQL - NULL 0:02:16

SQL - NULL Values - W3Schools.com

Statistical Significance, the 0:01:59

Statistical Significance, the Null Hypothesis and P-Values Defined & Explained in One Minute

How NULL values 0:00:38

How NULL values work in SQL queries | SQL Interview Question

Working with SQL 0:11:18

Working with SQL NULL values | Null Handling Functions

Top 5 Best 0:00:14

Top 5 Best practices to handle Null Values in SQL?

Master NULL Values 0:00:42

Master NULL Values Fast: Explained in Under 1 Minutes!

How to handle 0:05:24

How to handle NULL values in SQL ? | SQL COALESCE Function with examples

Lec-113: How Aggregate 0:07:23

Lec-113: How Aggregate Functions work on NULL Values | SQL | DBMS

Python Bangla Tutorial 0:07:11

Python Bangla Tutorial 64 | Handle Null Values in Pandas with Mean Imputation @DrMSRahman

NULL Values In 0:08:42

NULL Values In SQL | IN Clause | Expected Question | DBMS Session 40

SQL Null Function 0:00:20

SQL Null Function to check value of column is null or not

SQL Tutorial: Working 0:09:34

SQL Tutorial: Working with NULL values in T-SQL

Dealing with Null 0:03:28

Dealing with Null Values In Where Clause

replace null values 0:00:22

replace null values in power bi #shorts #dataanalytics #powerbi #sql #trendingshorts

What are NULL 0:01:00

What are NULL values?

How to work 0:03:40

How to work with null values in SQL| SQL For Data Science Beginner | SQL Tutorial - 10

Handling Null Values 0:00:36

Handling Null Values in MySQL #mysql #database #databasemanagement

Power Query Tricks! 0:00:50

Power Query Tricks! Unpivot & Keep Null Values

Database Systems - 0:02:48

Database Systems - NULL Values

Null Values in 0:01:39

Null Values in SQL

Null Values in 0:00:38

Null Values in SQL Server! | SQL Null Values | SQL Server | #sql #sqlserver

Making Sense of 0:09:26

Making Sense of Null Values in SQL Joins: What You Need to Know!

Topic- 17 Working 0:04:23

Topic- 17 Working with NULL values in mysql

Understanding NULL Values 0:00:50

Understanding NULL Values in SQL: What They Are and How to Handle Them

Комментарии
Автор

I am one of your students since 2015 and cracked many interview watching your video

gitagyan
Автор

Technically it should be null. Null = null is null because you don't know it what null is. (I.e. null = null unknown)

paulvanderveen
Автор

Simple for who .., cause you knew the answer before or folks who never knew it .., rote is the way

baner
Автор

False because null values can't be compared

TAGamerz
Автор

I knew this, it’s a bad feature. Unintuitive, reduced functionality, produces unexpected behavior. HOWEVER given the use case of the language if it wasn’t like that it would be really annoying.

_sleepy-