How do I get the most recent value from a table in QuestDB?

Question

I have a table that looks something like the following:

What query do I need to get the most recent record back?

score 1 · Accepted Answer · answered Mar 19 '21 at 14:32

There are two simple ways of getting the most recent values here, firstly, you can limit to the most recent row:

SELECT * FROM my_table LIMIT -1;

But what might be more useful in this case is to use LATEST BY:

SELECT * from my_table LATEST BY loc;

This would return the most recent rows per unique value in the loc column:

loc	temp	timestamp
xyz	21.4	2021-03-03T16:51:56.915000Z
abc	21.4	2021-03-03T17:05:38.238478Z

Edit: More information, along with examples can be found on the LATEST BY documentation

1 Answers1