SQL Server问题求解

[自由心证]

有以下一张表：
id times price
1 123 123
2 234 234
.. ... ...
要求按以下格式输出
id times price
1 123 123
2 234 234
.. ... ...
总计 357 357
注意：总计一行和前面数据一起输出，属于同一个记录集

[GodHack]

select convert(varchar,id), times, price
from TableName
union
select '总计',sum(times),sum(price)
from TableName

[IronPromises]

select id, times, price
from TableName
union
select '总计',sum(times),sum(price)
from TableName

[yehuazi]

select id ,times,price from table2
union
select sum(id),sum(times),sum(price) from table2 order by id
总计一行在最后.

[arfeiz]

对IronPromises(铁诺)的一点补充：
id列不能是主键并且该列的数据类型不能为数值型。