From Excel to SQL - Filtering Data (WHERE)

Filtering data is one of the most fundamental operations in the data world, and doing it in SQL is very similar to doing it in Excel! The dbfiddle website can be accessed for free and without an account at: - https://dbfiddle.uk/ Make sure to use the SQL Server dialect and the AdventureWorks sample database to be able to follow along with these examples! --------------------------------------------------- This is part of the From Excel to SQL playlist, available at: - https://www.youtube.com/playlist?list=PLEiRgvTilK5rhnVPQ_Tj3Q-CI0rGn_uiD Check out the previous video at: - https://youtu.be/vQka5zeU_so ...and the next video at: - https://youtu.be/yaomCldxZi4 The written version of this content is also available at: - https://billwallis.github.io/sql-learning-materials/from-excel-to-sql/main-concepts/where/ --------------------------------------------------- CHAPTERS 00:00 Intro 01:06 Recap 01:52 Filtering for a number 03:17 Filtering for some text 05:09 Filtering for a range 07:45 Filtering *not* equals 09:06 Filtering by a list 10:47 Filter by multiple conditions 16:20 Filtering missing data 19:39 Wrap up