"order by" And "limit = 1" Folks, I want to SELECT the single highest value of x. What does
"Order by" really order, the full set of table rows before the single
selection is returned, or only the returned row? (which wd clearly be
useless in this case.)
Or is there better SQL? Thanks.
AS |