- 论坛徽章:
- 0
|
回复 4# yuhuohu
根据三思大哥的Sql, 作一点修改就可以满足你 的要求了,
不过个人优化一下,如果这个只是报表还行,实时查询的话,表设计就有问题了。
还有lz大哥这么多分,才给5分
mysql> select * from t_group;
+------+---------------------+--------+
| user | time | salary |
+------+---------------------+--------+
| a | 2012-04-10 10:10:10 | 1 |
| b | 2012-04-10 10:10:10 | 2 |
| c | 2012-04-10 10:10:10 | 3 |
| d | 2012-04-10 10:10:10 | 4 |
| a | 2012-04-11 22:10:10 | 50 |
| b | 2012-04-11 11:10:10 | 12 |
| b | 2012-04-10 11:10:10 | 12 |
+------+---------------------+--------+
7 rows in set (0.00 sec)
mysql> select time ,max(ss) from (select time,sum(salary) ss from t_group group by date_format(time,'%Y-%m-%d:%k') )a group by date(time);
+---------------------+---------+
| time | max(ss) |
+---------------------+---------+
| 2012-04-10 10:10:10 | 12 |
| 2012-04-11 11:10:10 | 50 |
+---------------------+---------+
2 rows in set (0.00 sec)
|
|