简单的sql语句

求一个简单的sql语句
表:
name,date,money,tex
求语句:
把所有列全部列出来,然后再最后加上一行money的总计

谁会??我写了半天除了总计之外还多了一行按date的每天小计...郁闷

[解决办法]

SQL code

select name,date,money,tex from tunion allselect null,null,sum(money),null from t
[解决办法]
探讨


select name,date,money,tex from vote
union 
select null,null,sum(money),null from vote

[解决办法]
selct  
name,date,money,tex ,money_total from
(select name,date,money,tex  from table1) a,
(select sum(money) as money_total  from  table1) b

[解决办法]
select name,date,money,tex from tablename
union  
select null,null,sum(money),null from tablename
[解决办法]
select name,date,money,tex from tablename
union 
select null,null,sum(money),null from tablename