Drupal View for the 10 Most Recent Items Sorted by Date ASC Is it possible to construct a view of the 10 most recent nodes sorted by date in ascending order?

This sounds simple, but it seems as if it's more complicated than I'd imagined.

I think to do this in SQL you'd need a subquery, and I can't see that views is capable of that...

...or is it possible to reverse the order of the rows in the view after they're brought back from the database?
Have a look in the following image. This is a view of the 10 most recent nodes, sorted by post date (ascending).



If you meant to something else, please clarify the question.

If its a working solution for you, you are more than welcome to accept the answer by clicking on the checkmark ✓ (and thumb up if you liked it very much).