Query data with SQL

SHOW TABLES

SHOW COLUMNS IN measurement

SELECT temp, room FROM home WHERE time >= now() - INTERVAL '1 day'

SELECT  mean(field1) AS mean,  selector_first(field2)['value'] as first,  tag1 FROM home GROUP BY tag

SELECT  DATE_BIN(INTERVAL '1 hour', time, '2022-01-01T00:00:00Z') AS time,  mean(field1),  sum(field2),  tag1 FROM home GROUP BY 1, tag1

-- CAST clause SELECT CAST(1234.5 AS BIGINT)  -- Double-colon casting shorthand SELECT 1234.5::BIGINT

SELECT  time,  room,  temp,  temp - LAG(temp) OVER (  PARTITION BY room  ORDER BY time  ) AS temp_change FROM home ORDER BY room, time

SELECT  date_bin_gapfill(INTERVAL '30 minutes', time) as _time,  room,  interpolate(avg(temp)) FROM home WHERE  time >= '2022-01-01T08:00:00Z'  AND time <= '2022-01-01T10:00:00Z' GROUP BY _time, room

// Use the $parameter syntax to reference parameters in a query. // The following SQL query contains $room and $min_temp placeholders. query := `  SELECT * FROM home  WHERE time >= $min_time  AND temp >= $min_temp  AND room = $room`  // Assign parameter names to input values. parameters := influxdb3.QueryParameters{  "room": "Kitchen",  "min_temp": 20.0,  "min_time": "2024-03-18 00:00:00.00",   }  // Call the client's function to query InfluxDB with parameters. iterator, err := client.QueryWithParameters(context.Background(), query, parameters)