SQL ORDER BY bandi
SQL ORDER BY saralash
ORDER BY kalit so‘zi natijalar to‘plamini o‘sish yoki kamayish tartibida saralash uchun ishlatiladi.
ORDER BY kalit so‘zi natijalar to‘plamini sukut bo‘yicha o‘sish tartibida (ASC) saralaydi.
Misol
Mahsulotlarni eng arzonidan eng qimmatiga qarab saralash:
SELECT * FROM Products
ORDER BY Price;
O‘zingiz sinab ko‘ring »
ORDER BY sintaksisi
SELECT column1, column2, ...
FROM table_name
ORDER BY column1, column2, ... ASC|DESC;
Demo ma’lumotlar bazasi
Quyida misollarda foydalanilgan Products jadvalidan tanlanma keltirilgan:
| ProductID | ProductName | SupplierID | CategoryID | Unit | Price |
|---|---|---|---|---|---|
| 1 | Chais | 1 | 1 | 10 boxes x 20 bags | 18 |
| 2 | Chang | 1 | 1 | 24 - 12 oz bottles | 19 |
| 3 | Aniseed Syrup | 1 | 2 | 12 - 550 ml bottles | 10 |
| 4 | Chef Anton's Cajun Seasoning | 2 | 2 | 48 - 6 oz jars | 22 |
| 5 | Chef Anton's Gumbo Mix | 2 | 2 | 36 boxes | 21.35 |
ORDER BY DESC
Yozuvlarni kamayish tartibida saralash uchun DESC kalit so‘zidan foydalaning.
Misol
Mahsulotlarni eng qimmatidan eng arzoniga qarab saralash:
SELECT * FROM Products
ORDER BY Price DESC;
O‘zingiz sinab ko‘ring »
Alifbo bo‘yicha saralash
Matnli qiymatlar uchun ORDER BY kalit so‘zi ustundagi qiymatlarni alifbo tartibida saralaydi:
Misol
ProductName ustunini alifbo tartibida saralash:
SELECT * FROM Products
ORDER BY ProductName;
O‘zingiz sinab ko‘ring »
Alifboga teskari tartibda (DESC)
Ustundagi matnli qiymatlarni kamayish tartibida saralash uchun DESC kalit so‘zidan foydalaning:
Misol
ProductName ustunini alifboga teskari tartibda saralash:
SELECT * FROM Products
ORDER BY ProductName DESC;
O‘zingiz sinab ko‘ring »
Bir nechta ustun bo‘yicha ORDER BY
Quyidagi SQL buyrug‘i Customers jadvalidan barcha mijozlarni tanlaydi va ularni Country hamda CustomerName ustunlari bo‘yicha saralaydi.
Bu shuni anglatadiki, avval Country bo‘yicha saralanadi, agar ba’zi yozuvlarning mamlakati bir xil bo‘lsa, ular CustomerName bo‘yicha saralanadi:
ASC va DESC-ni birlashtirish
Quyidagi SQL kodi Customers jadvalidan barcha mijozlarni tanlaydi, hamda ularni Country bo‘yicha o‘sish (ASC) va CustomerName bo‘yicha kamayish (DESC) tartibida saralaydi:
Video: SQL ORDER BY kalit so‘zi
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!