|M| Sql查询计算数据求方法tableidappleapplecountorangeorangecount1152105查出表格式如下idappleappleco
|M| Sql查询计算数据 求方法
table
id apple applecount orange orangecount
1 15 2 10 5
查出表格式如下
id apple applecount orange orangecount tatil
1 15 2 10 5 80
谢谢
[解决办法]
select id,apple, applecount, orange, orangecount,(apple * applecount + orange * orangecount) as tatil from table