怎么用sql语句显示的时候在最后一行统计出某列总额？

[sheyu8]

以知一表，怎么用sql语句显示的时候在最后一行统计出总额？
a
id Account_money
1 3
3 33
4 44
显示结果：
a
id Account_money
1 3
3 33
4 44
总额 80

[txlicenhe]

Select cast(id as varchar(10)) as id,Account_Money from a
Union all
Select '总额',sum(Account_money) from a

[pengdali]

Select cast(id as varchar(10)) id,Account_Money from a
union
select '总额',sum(Account_money) from a