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=1

insert 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。。但没整对。