This query returns a list of all species that have 5 or fewer hectads within a region.
![](https://docs.bsbi.org/media/pages/ddb/searching/example-searches/species-low-hectads/a6bed67544-1700063517/screenshot-2023-10-31-at-17.24.47-600x.jpg)
Apart from the usual clauses to exclude invalid records, the important elements are:
- Grouping by species (because infra-specific taxa would complicate things)
- Counting distinct hectads (rather than a count of records)
- Setting a maximum frequency on the grouped total (hectads in this case)
These options are available on the more options > grouping submenu