I have a table with first name, last name and amount, ordered in descending order by the amount.
I want to get the first and last names in the first row (with max amount).
How can 'MAX' be used in this case? (There is no aggregation; first name + last name are all unique)
Before reading this I thought LIMIT 1 is a good option (because they're ordered) but now you said we can't use it.