SQL 求和

select name,money,date from (
select '1'+name as ord1, name,money,date from A
union
select '1'+name+'1' as ord1,'合计',sum(money),'' from A group by name
union
select '2','总计',sum(money),'' from A ) tmp order by ord1,date

其中日期在合计和总计时，如果‘’提示说不行，就用null吧，看你数据库存的日期的格式是什么

select rtrim(name)+'(合计)' as name,sum(money) as money,'' as date from A group by name
union
select * from A
order by name

select su as sum(money) from 表名 where name = '张三'
if not rs.eof the
response.write(su)