分组求和

Question

SELECT
    po_num, arr_adress, over_time, c_type, cust_no, SUM(mount), SUM(snp), SUM(totals),
    late_time
FROM
    dfl_stock_detail
WHERE
    po_num='SU14031300621'
GROUP BY
    po_num, arr_adress, over_time, c_type, cust_no,late_time

Answer 1

结果不对啊，不需要对snp进行求和SU14031300621 A1 2014-03-20 13:55:00.000 L11K 23703EX80A 24 30 360 2014-03-15 15:30:00.000
SU14031300621 A1 2014-03-20 13:55:00.000 L11K 23703JX30A 1 15 15 2014-03-15 15:30:00.000

Answer 2

SNP是哪个字段?不求和的话就去掉SUM 在GROUP BY 后面加上SNP字段

Answer 3

23703JX30A 取这个的时候有什么规则没？

Answer 4

SELECT
    po_num, arr_adress, over_time, c_type, MIN(cust_no), SUM(mount), snp, SUM(totals),
    late_time
FROM
    dfl_stock_detail
WHERE
    po_num='SU14031300621'
GROUP BY
    po_num, arr_adress, over_time, c_type, late_time,snp
是不是这样？