how to get latest timestamp data

1.2k views Asked by At

I am new to influx db, please help me with query?

I have below like data in influx where same Name data (A1, A2) can be available for multiple time.

I need only latest time stamp data (row 3,4,5) if same data is available in multiple time stamp and the new data (A3). Is such query available in influx?

this query only gives one record,

SELECT time, Name, value  FROM "data"  order by time desc limit 1

enter image description here

1

There are 1 answers

2
robert On BEST ANSWER

You can use the InfluxDB's last function to achieve this.

SELECT LAST("value") FROM AssetAssetType  GROUP BY "Name"