Cellwise · SQL track

Filtering rows with WHERE

Return only the rows that match.

WHERE is like a filter: only rows that pass its test come back. Text goes in single quotes, and numbers don’t.

Join several tests with AND when all must be true, or OR when any one is enough.

What you’ll do

• Filter on text
• Filter on a number
• Combine conditions