查询同一个字段，值相同的数据

Question

order_info表:
+----------+-------+------------+------------+----------+---------------------+-------+
| order_id | user  | food_name  | food_price | food_num | time                | check |
+----------+-------+------------+------------+----------+---------------------+-------+
| 1        | hekey | 红烧肉     | 12         | 1        | 2009-11-06 15:42:51 | 0     |
| 2        | hekey | 红烧肉     | 11         | 2        | 2009-11-06 15:42:51 | 0     |
| 4        | hekey | 番茄蛋     | 12         | 2        | 2009-11-06 15:43:51 | 0     |
| 5        | hekey | 番茄蛋     | 11         | 1        | 2009-11-06 15:43:51 | 0     |
| 6        | hekey | 平菇肉片   | 111        | 1        | 2009-11-06 15:43:51 | 0     |
+----------+-------+------------+------------+----------+---------------------+-------+查询time值相同的记录。比如order_id  1,2 的time就相同，把他们2个分为一组进行数据统计。

Answer 1

比如id为1，2的记录time就相同，统计这2个记录的food_num的值的总和之类的。

Answer 2

select time,sum(food_num) from tt group by time

Answer 3

否则只能猜你要的结果。select user,food_name,time,sum(food_price*food_num)
from order_info
group by user,food_name,time