3 ms·
I think this is a convenient side-effect of the implementation which was later turned into official behaviour. A bit like Python dictionary key ordering. In Po
by globular-toast 3y ago
I think this is a convenient side-effect of the implementation which was later turned into official behaviour. A bit like Python dictionary key ordering.
In Postgres you can do similar things with a DISTINCT ON query.
I always found this one of the hardest simple things to do in SQL.
- ealexhudson 3y agoI 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).