COUNT, DISTINCT, and NULLs in SQL Server

Опубликовано: 13 Октябрь 2024
на канале: Bert Wagner
18,990
191

NULLs are interesting values. While they fill an important need in the database, it's not always intuitive how different SQL Server statements and functions handle them.

This week we examine how COUNTs and DISTINCTs interact with NULLs...and how they may not always be doing what you expect with them.

Subscribe and turn on notifications to never miss a weekly video: https://www.youtube.com/c/DataWithBer...

Related blog post with more examples:
https://bertwagner.com/2019/02/19/cou...

Follow me on Twitter:
  / bertwagner