Question

SQL 求和语句就是GROUP by的sum，在线等

求full money的求和的sql语句

Answer 1

select company_id,budget_id,sum(full_money),sum(check_money)
from tmsdz.r_main
group by company_id,budget_id

Answer 2

select 列名,sum(FILL_MONEY) FILL_Money from tmsfz.r_Main where company_id='A320100' and budget_id='740910' group by 列名