gpt4 book ai didi

sql:对所有先前分组的行求和

转载 作者:行者123 更新时间:2023-11-29 11:58:43 24 4
gpt4 key购买 nike

<分区>

我有下表:

  date     | shop_id | package_id | quantity
01/01/2017 | 1 | 1 | 1
01/01/2017 | 1 | 2 | 5
01/01/2017 | 2 | 1 | 10
01/01/2017 | 2 | 2 | 4
02/01/2017 | 1 | 1 | 14
02/01/2017 | 1 | 2 | 3
....

我想把之前同店同包的所有记录的数量加起来,如下

  date     | shop_id | package_id | sum_quantity
01/01/2017 | 1 | 1 | 1
01/01/2017 | 1 | 2 | 5
01/01/2017 | 2 | 1 | 10
01/01/2017 | 2 | 2 | 4
02/01/2017 | 1 | 1 | 15
02/01/2017 | 1 | 2 | 8

....

24 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com