How can I specify sql sort order in sql query

Question

Hi,

I have the follow SQL query statement:

SELECT subject, sender_list, date, uid
FROM messages
WHERE folder_id = 3

Can you please tell how can I specify query sort order?

Thank you.

Answer 1

Hello Michael,

It's actually quite easy. Here's an example to sort your query by the "subject":

SELECT subject, sender_list, date, uid
  FROM messages
 WHERE folder_id = 3
 ORDER BY subject ASC

This will order your list A-Z. If you want to order your list Z-A then use:

ORDER BY subject DESC

Regards,
Andrew

Answer 2

Use the "ORDER BY"

For more information check out w3schools