SQL Switching output order

Question

I couldn't find this anywhere and I am having a hard time to fix this.

Here is my SQL query:

SELECT id, subject, content, description, date, image
FROM articles
WHERE id > $lastid
ORDER BY id ASC
LIMIT 5

This give me output in a following order id 11,12,13,14,15.

Is there a way to switch this output so it would be id 15,14,13,12,11?

Add another query to use this as a subquery and sort the other way. — Sami Kuhmonen
– Sami Kuhmonen, Commented Feb 12, 2018 at 14:30

rollstuhlfahrer · Accepted Answer · 2018-02-12 14:29:19Z

1

SELECT * FROM (
    SELECT id, subject, content, description, date, image FROM articles WHERE id > $lastid
    ORDER BY id ASC
    LIMIT 5
) t
ORDER BY id DESC

The documentations tells you that there are two ways to sort: ascending and descending. The corresponding sql elements are:

ORDER BY [Field] ASC for ascending and
ORDER BY [Field] DESC for descending.

edited Feb 12, 2018 at 14:29

answered Feb 12, 2018 at 14:27

rollstuhlfahrer

4,0789 gold badges28 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Vojtěch Šafařík Over a year ago

This give me this output id 20-16 as I got newer articles in DB. Basically I ve got query asking for Newer articles so I grab first article id that was used and ask for articles where id > $firstid

rollstuhlfahrer Over a year ago

You didn't mention that in your question. Edited my answer to reflect that

jarlh Over a year ago

@VojtěchŠafařík, don't forget to upvote/accept the answer!

Collectives™ on Stack Overflow

SQL Switching output order

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related