Скачать или смотреть 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:

   • From Excel to SQL  

Check out the previous video at:

   • From Excel to SQL - Getting Data (SELECT a...  

...and the next video at:

   • From Excel to SQL - Sorting Data (ORDER BY)  

The written version of this content is also available at:

https://billwallis.github.io/sql-lear...

---------------------------------------------------

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