http://www.2cto.com/database/201305/209283.html
[sql]
SELECT Customer, OrderDate, count(*)
FROM `all_orders`
GROUP BY Customer, OrderDate
FROM `all_orders`
GROUP BY Customer, OrderDate
结果为:
![](http://up.2cto.com/2013/0509/20130509095436257.png)
如果不加 GROUP BY的选项,得到
![](http://up.2cto.com/2013/0509/20130509095500728.png)
可以看出,count数的是行数,因为没有给出分类的条件,它数出了6条,但是customer和orderDate就是乱给的了
如果我想得到每个customer的object总数,则
[sql]
SELECT Customer, OrderDate, count(*)
FROM `all_orders`
GROUP BY Customer, OrderDate
FROM `all_orders`
GROUP BY Customer, OrderDate
得到
![](http://up.2cto.com/2013/0509/20130509095509214.png)