Use comparison operators

sql

SELECT *
FROM invoices
WHERE amount > 1000
  AND due_date < CURRENT_DATE;

Explanation

Combine predicates with AND and OR to express complex filters.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Filtering Rows

Return rows matching an exact value.

Open In sheetsqlsame section

Match any value from a list.

Open In sheetsqlsame section

Filter a value within an inclusive range.

Open In sheetsqlsame section

Find rows using wildcard patterns.

Open In sheetsqlsame section

Filter rows with missing values.

Open In sheetsqlsame section

Return all columns from a table.