行的合计是有的,只是一般来说,一行的数据一般是不同类型的,行的合计需要自己选择哪些列。所以一般:select name,a,b,c,a+b+c as total
from tablenameor:select name,sum(a) as a,sum(b) as b,sum(c) as c,sum(a+b+c) as total
from tablename
group by name
from tablenameor:select name,sum(a) as a,sum(b) as b,sum(c) as c,sum(a+b+c) as total
from tablename
group by name
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货