while reading the sqlite change log I came across this statement
2012-03-20 (3.7.11)
...
Queries of the form: "SELECT max(x), y FROM table" returns the value of y on the same row that contains the maximum x value.
...
I found the commits that implement this feature, in the hope of finding documentation but no luck.
I find myself using this feature all the time and wondering:
- Is there documentation of this feature?
- When can I rely on it applying?
- Are there gotchas in using it?
- Are there similar queries that it doesn't work for?
Aucun commentaire:
Enregistrer un commentaire