How to Compare Lists in SQL Server
In this episode, we’ll return to our data engineering playlist in order to show how to compare two lists in SQL Server and find out which items are in one list but not another, and vice versa. This is an important query to learn for comparing large lists which might be hard to compare otherwise (think millions of rows).
Thinking of a data warehouse project? Contact me today!