PostgreSQL ORDER BY
Ma’lumotlarni saralash
ORDER BY kalit so‘zi natijani o‘sish yoki kamayish tartibida tartiblash uchun ishlatiladi.
ORDER BY kalit so‘zi sukut bo‘yicha yozuvlarni o‘sish tartibida tartiblaydi. Yozuvlarni kamayish tartibida saralash uchun DESC kalit so‘zidan foydalaning.
Misol
Jadvalni narx bo‘yicha tartiblang:
SELECT * FROM products
ORDER BY price;
Misolni ishga tushirish »
DESC
ORDER BY kalit so‘zi sukut bo‘yicha yozuvlarni o‘sish tartibida tartiblaydi. Yozuvlarni kamayish tartibida saralash uchun DESC kalit so‘zidan foydalaning.
Misol
Jadvalni narx bo‘yicha kamayish tartibida tartiblang:
SELECT * FROM products
ORDER BY price DESC;
Misolni ishga tushirish »
Alifbo tartibida tartiblash
String qiymatlar uchun ORDER BY kalit so‘zi alifbo tartibida tartiblaydi:
Misol
Jadvalni mahsulot nomi bo‘yicha tartiblang:
SELECT * FROM products
ORDER BY product_name;
Misolni ishga tushirish »
Alifbo tartibida DESC
Jadvalni alifbo tartibida teskari saralash uchun DESC kalit so‘zidan foydalaning:
Misol
Jadvalni mahsulot nomi bo‘yicha, kamayish tartibida tartiblang:
SELECT * FROM products
ORDER BY product_name DESC;
Misolni ishga tushirish »
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!