Query data with SQL

SHOW TABLES

SHOW COLUMNS IN table

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'::TIMESTAMP) 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
  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 1, 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)