sql怎么求两列的和

㈠ mysql数据库有两列数据,怎么求和,具体看详情!

select sum(case b is null when a else b end) from table;

㈡ SQL语句怎么实现两列内容相加

select a+b from table

㈢ sql 如何查询一个表中的两列之和

select column1+column2 as 和 from table

㈣ 求SQL两列数据求和

select IDependCode, sum(money1) as money3 from (select * from table1
union all
select * from table2
) as temp group by IDependCode

㈤ sql语句列求和

select sum(数据1)，sum(数据2) from table

如果表里只有这两列，则语句如上，如果还有其它列并且需要分组，则添加group by语句，如:
select sum(数据1)，sum(数据2) from table
group by 其它列

㈥ sql语句求两列的(相加)和

select sum(a+b) as c from table

如有疑问：加我：514895860

㈦ 怎么查询sql表两列相加的和

做个简单的。
两个数据表db1,db2

查询结果A是从数据表db1获取的：
select names, sale from db1

查询结果B是从数据表db2获取的：
select names, sale from db2

则查询结果C：

select names,sum(sale) as sale
from
(select names, sale from db1
union
select names, sale from db2
)
group by names

㈧ sql 计算结果两列的和

selectsum(xxxx)asa,sum(xxxx)asb,sum(xxxx)+sum(xxxx)ascfromxxxxx

㈨ sql怎么把一行数据中的几列相加

1、创建测试表，create table test_num(fee_id number, fee1 number, fee2 number, fee_3 number);