Notes to Read When SQL Counts Don't Match: 6 Exercises to Isolate NULLs, Duplicates, and JOINs

Even though you intend to count the same data, your SQL returns 100 records, while the person you are verifying with gets 98.In such cases, if you immediately add conditions just to make the numbers ...
Ars Technica

Settle an argument: SQL update with left join + isnull() vs inner join

I've been in an argument with one of our devs that took an update statement with an inner join and made it a left join (because inner was missing some records somehow in the left table - tableB in ...
Simon Fraser University

IS condition

IS NULL and IS MISSING are predicates that test for a missing value. IS NULL and IS MISSING are used in the WHERE, ON, and HAVING expressions. Each predicate resolves to true if the sql-expression's ...