Query first and last values

By default, InfluxDB returns results sorted by time, however you can use the to change how results are sorted. and last() respect the sort order of input data and return records based on the order they are received in.

returns the first non-null record in an input table.

Given the following input:

last

last() returns the last non-null record in an input table.

Given the following input:

The following function returns:

Given the following input:

The following function returns:

last

Related

• first() function