SQLite Forum

Can this simple query be optimized?
Hi Keith, sorry the reply was not meant on your post, but on the original post, and I agree the "x" is a mistake and should read "(x/10)" as was my intent.

More importantly, I know that is not the data sought in the original, my post was more intended tongue-in-cheek to point out the silliness of NOT getting both minima and maxima in one line, especially since the OP was willing to program an entire piece of extra code to speed things up slightly - you'd think reading one more field would be very painless next to that.