" /> " /> JoomThumbnail
Галоўная SQL Group By
SQL Group By

GROUP BY

Сінтаксіс SQL GROUP BY

SELECT column_name, aggregate_function(column_name)
FROM table_name
WHERE column_name operator value
GROUP BY column_name

Прыклад SQL GROUP BY

Ёсць наступная табліца "Orders":

O_IdOrderDateOrderPriceCustomer
1 2008/11/12 1000 Hansen
2 2008/10/23 1600 Nilsen
3 2008/09/02 700 Hansen
4 2008/09/03 300 Hansen
5 2008/08/30 2000 Jensen
6 2008/10/04 100 Nilsen

для кожнага кліента.

Выканаем запыт:

1
2

SELECT Customer,SUM(OrderPrice) FROM Orders
GROUP BY Customer

Вынік запыту:

CustomerSUM (OrderPrice)
Hansen 2000
Nilsen 1700
Jensen 2000 

1

SELECT Customer,SUM(OrderPrice) FROM Orders

Вынік запыту:

CustomerSUM (OrderPrice)
Hansen 5700
Nilsen 5700
Hansen 5700
Hansen 5700
Jensen 5700
Nilsen 5700 

1
2

SELECT Customer,OrderDate,SUM(OrderPrice) FROM Orders
GROUP BY Customer,OrderDate

 
+8 #1 seitbekir 2009-11-20 17:32
 
 
+19 #2 Lightxlampa 2010-03-14 13:42
 
 
-7 #3 Анна 2010-08-03 12:17
 
 
-4 #4 ageent 2010-08-03 18:50
 
 
-8 #5 STEREOLOVER.CS 2010-08-10 09:57





















 
 
+5 #6 Шелест Константин 2010-10-29 00:50
 
 
-5 #7 Артур Пирожков 2011-04-19 13:53










-



-
 
 
0 #8 Рамиль 2011-04-27 12:01
 
 
+5 #9 Lirriella 2011-06-22 14:40
 
 
0 #10 Максим 2011-11-23 14:28 Quoting ageent:
 

Аўтарызацыя

Nice Ajax Poll

Статыстыка

Рэклама
© 2009 ageent.ru.