select name,date,money,tex from t
union all
select null,null,sum(money),null from t
------解决方案--------------------
------解决方案-------------------- 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