Lesson 7. Advanced Data Filtering

In this lesson, you learn how to combine WHERE clauses to create powerful and sophisticated search conditions. You also learn how to use the NOT and IN operators.

Combining WHERE Clauses

All the WHERE clauses introduced in Lesson 6, “Filtering Data,” filter data using a single criteria. For a greater degree of filter control, T-SQL allows you to specify multiple WHERE clauses. These clauses may be used in two ways: as AND clauses or as OR clauses.

New Term: Operator

A special keyword used to join or change clauses within a WHERE clause. Also known as a logical operator.

Using the AND Operator

To filter by more than one column, you use the AND operator to append conditions to your WHERE clause. The following ...

Get Sams Teach Yourself Microsoft® SQL Server T-SQL in 10 Minutes, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.