LIMIT and SLIMIT clauses

Use LIMIT to limit the number of rows returned per InfluxQL group. Use SLIMIT to limit the number of series returned in query results.

• LIMIT clause
  • Syntax
  • Examples
• SLIMIT clause

LIMIT clause

The LIMIT clause limits the number of rows to return from each InfluxQL group. If the query doesn’t include a GROUP BY clause, the entire result set is considered a single group. If a query groups data by time, limits are applied after aggregate and selector operations are applied to each time window.

Syntax

SELECT_clause FROM_clause [WHERE_clause] [GROUP_BY_clause] [ORDER_BY_clause] LIMIT N

Arguments

• N: Maximum number of points to return from each InfluxQL group. If N is greater than the number of points in a group, all points from the group are returned.

Examples

The following examples use the Get started home sensor sample data.

SELECT * FROM home LIMIT 3

SELECT
  MEAN(*)
FROM home
GROUP BY
  time(2h),
  room
LIMIT 3

SLIMIT clause