mysql 多表with rollup_mysql with rollup 多组统计 如何去掉子项汇总，保留最后条汇总？-问答-阿里云开发者社区-阿里云...

如题，现有报表统计需求，需统计每天的工作量，但不想显示子项统计，只想保留最后一条统计数据，该如何写语句？

代码如下：CREATE TABLE `work_log` (

`id` int(5) unsigned NOT NULL AUTO_INCREMENT,

`name` varchar(10) DEFAULT '',

`work_date` varchar(10) DEFAULT '',

PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=1insert into work_log(name,work_date) values

('1000','2012-10-11'),('1000','2012-10-12'),('1000','2012-10-13'),('1000','2012-10-14'),('1001','2012-10-11'),('1001','2012-10-12'),('1001','2012-10-13')

,('1001','2012-10-14'),('1001','2012-10-16'),('1002','2012-10-11')select name,work_date ,count(*) as counts

from work_log

group by name,work_date

with ROLLUP+------+------------+--------+

| name | work_date | counts |

+------+------------+--------+

| 1000 | 2012-10-11 | 1 |

| 1000 | 2012-10-12 | 1 |

| 1000 | 2012-10-13 | 1 |

| 1000 | 2012-10-14 | 1 |

| 1000 | NULL | 4 |

| 1001 | 2012-10-11 | 1 |

| 1001 | 2012-10-12 | 1 |

| 1001 | 2012-10-13 | 1 |

| 1001 | 2012-10-14 | 1 |

| 1001 | 2012-10-16 | 1 |

| 1001 | NULL | 5 |

| 1002 | 2012-10-11 | 1 |

| 1002 | NULL | 1 |

| NULL | NULL | 10 |

+------+------------+--------+

14 rows in set (0.00 sec)

如上，想把1000 | NULL | 4

1001 | NULL | 5

1002 | NULL | 1

这种统计行去掉不显示，只显示最下面的那条统计，改如何写语句呢？ 试过having。。但没整对。