In my application, I often want to select one row from a database
which is the most of something. Perhaps I want the most recent row
corresponding to a certain user. One way to do this is to
SELECT .... SORT BY date LIMIT 1
but I can't believe that this is an efficient way to do it. Or is it?
Thanks,
Dr Evil