MIN() and MAX()

SQL MIN() va MAX() Funktsiyalari

MIN() va MAX() funktsiyalari tanlangan ustundagi eng kichik va eng katta qiymatlarni qaytarish uchun ishlatiladi.

MIN() funktsiyasi tanlangan ustundagi eng kichik qiymatni qaytaradi.
MAX() funktsiyasi tanlangan ustundagi eng katta qiymatni qaytaradi.

Sintaksis

SELECT MIN(column_name)
FROM table_name
WHERE condition;
 
SELECT MAX(column_name)
FROM table_name
WHERE condition;

Misollar

MIN() Misoli Narxlar ustunidagi eng kichik narxni topish:

SELECT MIN(Price) AS SmallestPrice
FROM Products;

MAX() Misoli Narxlar ustunidagi eng katta narxni topish:

SELECT MAX(Price) AS LargestPrice
FROM Products;

Demo Ma'lumotlar Bazasi

Quyidagi jadval misol sifatida Products jadvalidan olingan:

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

Ustun Nomini Berish

MIN() yoki MAX() funktsiyalaridan foydalanganda, qaytarilgan ustunning tavsiflovchi nomi bo'lmaydi. Tavsiflovchi nom berish uchun AS kalit so'zidan foydalaning:

SELECT MIN(Price) AS SmallestPrice
FROM Products;

GROUP BY bilan MIN() dan Foydalanish

MIN() funktsiyasini va GROUP BY klauzasini birgalikda ishlatish orqali har bir kategoriya uchun eng kichik narxni qaytarish mumkin:

SELECT MIN(Price) AS SmallestPrice, CategoryID
FROM Products
GROUP BY CategoryID;

Ushbu misolda har bir kategoriya uchun eng kichik narx qaytariladi.