order-by

ORDER BY natijani saralaydi: ASC — o‘sish (standart), DESC — kamayish.

SELECT name, price FROM products ORDER BY price DESC;
SELECT name, grade FROM students ORDER BY grade DESC, name ASC;   -- teng bo‘lsa — ism bo‘yicha

Maslahatlar

• Masalada «teng bo‘lsa…» degan qoida bo‘lsa, uni ikkinchi kalit sifatida qo‘shing — aks holda tartib tasodifiy bo‘lib, javob noto‘g‘ri chiqishi mumkin.
• Hisoblangan ustun yoki uning AS nomi bo‘yicha ham saralash mumkin.