On 17 Apr, 00:21, cami...@mit.edu wrote:
> I keep track of some documents for work, and have built an rss feed to
> show the most recent 20. A simplified version of the query is here:
>
> SELECT date_created, id, name
> FROM documents
> ORDER BY date_created desc
> LIMIT 0, 20
>
> This will show the most recent documents, with the most recent on the
> top. Is it possible to reverse the order of these last twenty?
>
> I'd like to have a list of the most recent documents, ordered ascending.
>
> Thanks,
> Charley

Here is one way:
SELECT * FROM (
SELECT date_created, id, name
FROM documents
ORDER BY date_created desc
LIMIT 0, 20 ) AS md
ORDER BY date_created