SQL AVG()
SQL AVG() funksiyasi
AVG() funksiyasi sonli ustunning o‘rtacha qiymatini qaytaradi.
AVG() funksiyasi ustundagi NULL qiymatlarni e’tiborsiz qoldiradi.
Misol
Barcha mahsulotlarning o‘rtacha narxini topish:
SELECT AVG(Price)
FROM Products;
O‘zingiz sinab ko‘ring »
Eslatma: NULL qiymatlari e’tiborga olinmaydi.
AVG() sintaksisi
SELECT AVG(column_name)
FROM table_name
WHERE condition;
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.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 |
WHERE bandini qo‘shing
Shartlarni belgilash uchun WHERE bandini qo‘shishingiz mumkin:
Misol
1-toifadagi mahsulotlarning o‘rtacha narxini qaytarish:
SELECT AVG(Price)
FROM Products
WHERE CategoryID = 1;
O‘zingiz sinab ko‘ring »
Taxallusdan foydalaning
AS kalit so‘zidan foydalanib, AVG ustuniga nom bering.
Misol
ustunini "o‘rtacha narx" deb nomlang:
SELECT AVG(Price) AS [average price]
FROM Products;
O‘zingiz sinab ko‘ring »
o‘rtachadan yuqori
Narxi o‘rtachadan yuqori bo‘lgan barcha yozuvlarni ro‘yxatlash uchun ichki so‘rovda AVG() funksiyasidan foydalanishimiz mumkin:
Misol
barcha mahsulotlar qiymatini o‘rtacha Pricedan yuqoriroq Price bilan qaytaring:
SELECT * FROM Products
WHERE Price >
(SELECT AVG(Price) FROM Products);
O‘zingiz sinab ko‘ring »
AVG() funksiyasini GROUP BY bilan ishlatish
Bu yerda "Products" jadvalidagi HAR BIR toifa uchun o‘rtacha narxni qaytarish maqsadida AVG() funksiyasi va GROUP BY bandidan foydalanamiz:
Misol
SELECT AVG(Price) AS AveragePrice, CategoryID
FROM Products
GROUP BY CategoryID;
O‘zingiz sinab ko‘ring »
Ushbu darslikning keyingi bo‘limlarida GROUP BY bandi haqida batafsilroq ma’lumot olasiz.
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!