WHERE

• InfluxDB: WHERE "youfielname" = 'yourvalue' (Note usage of " " for field and for value)
• https://docs.influxdata.com/influxdb/v2/query-data/influxql/explore-data/where/#Copyright

LIMIT

See also

• SELECT, GRANT SELECT ON, BETWEEN, ORDER BY, SELECT MAX