Gunakan ORDER BY untuk mengurutkan hasil query.

Ascending (kecil ke besar) — default:

SELECT * FROM users ORDER BY name;
SELECT * FROM users ORDER BY name ASC; -- sama saja

Descending (besar ke kecil):

SELECT * FROM products ORDER BY price DESC;

Urut berdasarkan beberapa kolom:

SELECT * FROM students ORDER BY grade DESC, name ASC;
-- Urutkan by grade (tertinggi dulu), jika grade sama urut by nama (A-Z)

Kombinasi dengan WHERE:

SELECT * FROM products
WHERE category = 'electronics'
ORDER BY price ASC;