bitscn.com 今天从mysql中提取数据，使用rollup统计后，想在数据左边列中加入项目名称，使用sql
sql代码 
select (case when isnull(playerno) then playerno=total else playerno end) as playerno,sum(amount) from penalties 
group by playerno with rollup 
 结果是：
这样
+----------+-------------+
| playerno | sum(amount) |
+----------+-------------+
|        6   |      100.00 |
|        8   |        25.00 |
|       27  |      175.00 |
|       44  |      130.00 |
|      104 |        50.00 |
|     null|      480.00 |
+----------+-------------+
6 rows in set, 1 warning (0.00 sec)
显示为空值，修改如下：
sql代码 
select playerno,sum(amount) from penalties 
group by playerno 
union 
select total,sum(amount) 
from penalties
显示结果：
+----------+-------------+
| playerno | sum(amount) |
+----------+-------------+
| 6          |      100.00 |
| 8          |        25.00 |
| 27        |      175.00 |
| 44        |      130.00 |
| 104      |        50.00 |
| total  |      480.00 |
+----------+-------------+
6 rows in set (0.00 sec) bitscn.com