ORDER BY

Query result sort করে।

Ascending:

SELECT *
FROM orders
ORDER BY amount ASC;

Descending:

SELECT *
FROM orders
ORDER BY amount DESC;

Multiple Sorts

SELECT *
FROM orders
ORDER BY
    city ASC,
    amount DESC;

মানে:

প্রথমে city।

Same city-এর মধ্যে highest amount আগে।