SELECT
sum( f.f_amount ) AS f_amount
FROM
t_warehousebillsfees AS f
GROUP BY
f.f_mblno,
f.f_dc ;
SELECT
sum( 求和字段名 ) AS 别名
FROM
表名 AS 别名
GROUP BY
分组字段名
sum() 求和函数
GROUP BY 分组
SELECT
sum( f.f_amount ) AS f_amount
FROM
t_warehousebillsfees AS f
GROUP BY
f.f_mblno,
f.f_dc ;
SELECT
sum( 求和字段名 ) AS 别名
FROM
表名 AS 别名
GROUP BY
分组字段名
sum() 求和函数
GROUP BY 分组