# FILL keyword

> **For AI agents:** the complete documentation index is at [llms.txt](https://questdb.com/docs/llms.txt). Every page is available as markdown by appending `.md` to its URL, or by sending an `Accept: text/markdown` request header.

FILL SQL keyword reference documentation.

Queries using a [SAMPLE BY](/docs/query/sql/sample-by/) aggregate on data
which has missing records may return a discontinuous series of results. The
`FILL` keyword allows for specifying a fill behavior for results which have
missing aggregates due to missing rows.

Details for the `FILL` keyword can be found on the
[SAMPLE BY](/docs/query/sql/sample-by/) page.

To specify a default handling for `null` values within queries, see the
[coalesce() function](/docs/query/functions/conditional/#coalesce)
documentation.