How Data is Stored and Moved

Filter

Narrowing down a dataset to only the records that match specific criteria.

Definition

Narrowing down a dataset to only the records that match specific criteria. In SQL this is done with a WHERE clause. Filtering is one of the most common data operations.

Example

Filtering a list of 10,000 products to show only those under $20 and in stock.

See it in context Learn how Filter fits into the bigger picture of how software actually works.

Read the Guide →