sql - 在 Postgresql 中将重复项组合在一起

Question

我正在查询以查看我们的仓库中有多少库存，我如何将所有重复的库存组合在一起，以便所有数量可以作为一个，并且同一产品不会显示多次？我将发布屏幕截图以显示我得到的内容和我正在使用的代码。谢谢

Duplicates example

select b.qty, a.part, a.desc1, a.main_supplier as supplier_acc_no, c.name as 
 supplier_name, a.main_mpn, a.date_receipt as date_booked_in
from public.stock as a
inner JOIN public.sthist AS b ON a.part = b.part
inner join public.supplier as c on a.main_supplier = c.account
where a.date_receipt > date_trunc('day', CURRENT_DATE) - INTERVAL '2 days'
and b.tran_type = 'POGRN'

Answer 1

求和和分组依据(以及任何非分组依据表达式的适当函数)。例如，

select sum(b.qty), a.part, min(a.desc1), 
min(a.main_supplier) as supplier_acc_no, min(c.name) as supplier_name, 
min(a.main_mpn), min(a.date_receipt) as date_booked_in
from public.stock as a
inner JOIN public.sthist AS b ON a.part = b.part
inner join public.supplier as c on a.main_supplier = c.account
where a.date_receipt > date_trunc('day', CURRENT_DATE) - INTERVAL '2 days'
and b.tran_type = 'POGRN'
group by a.part