Question

我有一个表:

id, cust#, payment, date
1, cus1, 508, 2010-01-01
2, cus2, 40, 2010-01-01
3, cus1, 13, 2010-01-02

我要问一下。

select id, cust#, payment, date group by cust#

预计会恢复结果。我需要将每一栏目的价值加上<代码>(付款)的总付款额的价值。

我可以指出这一点,因为只有这笔钱才能支付,而不是每个付款额加上总额。

select id, cust#, sum(payment), date group by cust#

这是在某种意义上的,尽管这不是一个有效的问题。

select id, cust#, payment, sum(payment) AS totalpayments, date group by cust#

Answer 1

您必须使用分局:

select
    id,
    cust#,
    (select 
        sum(payment) 
    from 
        mytable 
    group by 
        cust#
    ) as totalpayments, 
    date 
from
    mytable

友情链接