使用ORDER BY后反转PostgreSQL的结果

Question

I have a query where I need to select the latest 25 entries to my database, but inverse the order of the results of that select.

I've come up with:

SELECT indexID, datetime, temperature FROM dataB WHERE userID="4236" ORDER BY indexID DESC, datetime ASC LIMIT 25

But I'm still getting the results in chronological order starting from newest, but I want chronological oldest to newest WITHIN those 25 newest. I'm using PHP's pg_fetch_row() and creating a concatenated string with the results and feeding that into a Morris.js graph, where my data is being graphed backwards because of this query.

How do I reverse the results of a query?

Answer 1

You should try this , first fetch data in descending orders after that use as temporary table and again select in ascending order

SELECT indexID, datetime, temperature FROM (SELECT indexID, datetime, temperature FROM dataB WHERE userID="4236" ORDER BY indexID DESC LIMIT 25) temp order by indexID ASC