You are viewing a single comment's thread. Return to all comments →
why write "city asc limit 1" rather than just "asc limit 1"? It seems like this made a difference in getting the right answer, but not sure what change that made
I think if you erase "city" from "city asc limit 1" then it will not maintain the alphabetical order.
no need for the asc and desc in the "city asc limit 1", that won't do a thing. cmiiw
Yes, that is correct. That's why it happens.