SQLite Forum

Can this simple query be optimized?
Login
Again, this only produces "an X" where the minima or maxima was found.  Not the X where the max(y) was found and the (different) X where the min(y) is to be found.  That is, the X value is wrong 50% of the time (assuming (x/10,y) is unique).