Say you want to select the most recent 10 records (ORDER BY date DESC, LIMIT 10), but display them in ascending order… Just put the select as a temporary table in a subquery, and select from that result set with the order you want them returned: