3 ms·
I think if you have a set that you want the latest value from, in all engines you can do something explicit like: > SELECT manifest, versionId, checkinTime FRO
by ealexhudson 3y ago
I think if you have a set that you want the latest value from, in all engines you can do something explicit like:
> SELECT manifest, versionId, checkinTime FROM version ORDER BY checkinTime DESC LIMIT 1
The problem with putting aggregation functions in the select output is that you're being unclear about what is aggregating; that pattern begins to break down once you have e.g. multiple documents in the same schema. Or if versionId somehow wasn't linear (e.g. branches of changes).