• 使用sql语句对多个列进行求和.

    sum语句的基本用法是:select sum(列名) as A_Name from Table_Name where ...

    这样只能计算出某一列的数值的和;

    如果要求多列的和,则可用:select sum(列名1+列名2+列名n) as A_Name from Table_Name where...