mercredi 25 mars 2015

y from the same row as max x sqlite documentation

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