HAVING
HAVING
Yig‘ish funksiyalari bilan WHERE o‘rniga HAVING buyrug‘i ishlatiladi.
Quyidagi SQL har bir mamlakatdagi mijozlar sonini ko‘rsatadi. Faqat 5 dan ortiq mijozlari bo‘lgan mamlakatlarni o‘z ichiga oladi:
Misol
SELECT COUNT(CustomerID), Country
FROM Customers
GROUP BY Country
HAVING COUNT(CustomerID) > 5;
O‘zingiz sinab ko‘ring »
Quyidagi SQL har bir mamlakatdagi mijozlar sonini yuqoridan pastgacha saralab ko‘rsatadi (Faqat 5 dan ortiq mijozlari bo‘lgan mamlakatlar kiradi):
Misol
SELECT COUNT(CustomerID), Country
FROM Customers
GROUP BY Country
HAVING COUNT(CustomerID)
> 5
ORDER BY COUNT(CustomerID) DESC;
O‘zingiz sinab ko‘ring »
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!