MySQL ORDER BY

Kalit so‘z bo‘yicha MySQL TARTIBI

ORDER BY kalit so‘zi natijalar to‘plamini o‘sish yoki kamayish tartibida tartiblash uchun ishlatiladi.

ORDER BY kalit so‘zi sukut bo‘yicha yozuvlarni o‘sish tartibida (ASC) tartiblaydi.

Misol

Mahsulotlarni eng pastdan yuqori narxga saralash:

SELECT * FROM Products
ORDER BY Price;

O‘zingiz sinab ko‘ring »

Sintaksis bo‘yicha TARTIBI

SELECT column1, column2, ...
FROM table_name
ORDER BY column1, column2, ... ASC|DESC;

Demo ma’lumotlar bazasi

Quyida Northwind namunaviy ma’lumotlar bazasidagi “Mahsulotlar” jadvalidan tanlab olingan:

ProductID	ProductName	SupplierID	CategoryID	Unit	Price
1	Chais	1	1	10 boxes x 20 bags	18.00
2	Chang	1	1	24 - 12 oz bottles	19.00
3	Aniseed Syrup	1	2	12 - 550 ml bottles	10.00
4	Chef Anton's Cajun Seasoning	2	2	48 - 6 oz jars	22.00
5	Chef Anton's Gumbo Mix	2	2	36 boxes	21.35

DESC BUYUK BUYURTMA

Yozuvlarni kamayish tartibida saralash uchun DESC kalit so‘zidan foydalaning.

Misol

Mahsulotlarni eng yuqori narxdan eng past narxga saralash:

SELECT * FROM Products
ORDER BY Price DESC;

O‘zingiz sinab ko‘ring »

Demo ma’lumotlar bazasi

Quyida Northwind namunasidagi "Mijozlar" jadvalidan tanlov mavjud ma’lumotlar bazasi:

Mijoz ID	Mijoz nomi	Kontakt nomi	Manzil	Shahar	Pochta kodi	Mamlakat
1	Alfreds Futterkiste	Mariya Anders	Obere ko‘chasi. 57	Berlin	12209	Germaniya
2	Ana Trujillo Emparedados y helados	Ana Trujillo	Avda. de la Konstitutsiya 2222	Meksika D.F.	05021	Meksika
3	Antonio Moreno Taqueria	Antonio Moreno	Mataderos 2312	Meksika D.F.	05023	Meksika
4	Shox atrofida	Tomas Xardi	120 Gannover kv.	London	WA1 1DP	UK
5	Berglunds snabbköp	Kristina Berglund	Berguvsvägen 8	Luleå	S-958 22	Shvetsiya

Misol bo‘yicha tartib berish

Quyidagi SQL "Mamlakat" ustuni bo‘yicha tartiblangan "Mijozlar" jadvalidan barcha mijozlarni tanlaydi:

Misol

SELECT * FROM Customers
ORDER BY Country;

O‘zingiz sinab ko‘ring »

DESC BO‘YICHA BUYURTDIRISH Misol

Quyidagi SQL "Mijozlar" jadvalidan barcha mijozlarni tanlaydi va ularni "Mamlakat" ustuni bo‘yicha kamayishiga qarab tartiblaydi:

Misol

SELECT * FROM Customers
ORDER BY Country DESC;

O‘zingiz sinab ko‘ring »

Bir nechta ustunlar bo‘yicha BUYURTMA

Quyidagi SQL "Customers" jadvalidagi barcha mijozlarni "Country" va "CustomerName" ustunlari bo‘yicha tartiblab tanlaydi. Bu shuni anglatadiki, u avval Country bo‘yicha tartiblaydi, agar ba’zi yozuvlarda Country bir xil bo‘lsa, ularni CustomerName bo‘yicha tartiblaydi:

Misol

SELECT * FROM Customers
ORDER BY Country, CustomerName;

O‘zingiz sinab ko‘ring »

ASC va DESC ni birlashtiring

Quyidagi SQL "Mijozlar" jadvalidan barcha mijozlarni tanlaydi va ularni "Mamlakat" bo‘yicha o‘sish va "Mijoz nomi" ustuni bo‘yicha kamayish bo‘yicha tartiblaydi:

Misol

SELECT * FROM Customers
ORDER BY Country ASC, CustomerName DESC;

O‘zingiz sinab ko‘ring »

W3Schools Pathfinder

Yutuqlaringizni kuzating – bu bepul!

Ro'yxatdan o'tish Kirish