GROUP BY

GROUP BY buyrug‘i natijalar to‘plamini guruhlash uchun ishlatiladi (agregat funksiyalar bilan ishlatiladi: COUNT, MAX, MIN, SUM, AVG).

Quyidagi SQL har bir mamlakatdagi mijozlar sonini ko‘rsatadi:

SELECT COUNT(CustomerID), Country
FROM Customers
GROUP BY Country;

Quyidagi SQL har bir mamlakatdagi mijozlar sonini yuqoridan pastgacha tartiblangan holda ko‘rsatadi:

SELECT COUNT(CustomerID), Country
FROM Customers
GROUP BY Country
ORDER BY COUNT(CustomerID) DESC;

W3Schools Pathfinder

Yutuqlaringizni kuzating – bu bepul!