Skip to content

Numeric Filter ​

Numeric comparisons filter to specific value ranges.

Interactive Example ​

Try It
TABLE
  WHERE income > 50000
  ROWS occupation
  COLS gender * income.mean
;
Dataset:samplesoccupation, education, gender, income
Try Variations

Query Breakdown ​

  • WHERE income > 50000 - Filters to rows where income exceeds 50,000

Numeric filters support all comparison operators: >, <, >=, <=, =, !=.

Powered by Malloy and DuckDB