To separate the series, you can add GROUP BY *
, which will give you the results separated by series. Then you can add aggregates to your query, like LAST
.
For example:
SELCT LAST(field_name, *) from test_result GROUP BY *
Keep in mind that your fields are also a factor here. You can use *
without specifying a field, but there’s room for error there. It’s better to specify a field if you know what you need.