Group together duplicates in Postgresql

Question

I am making a query to see how much stock gets booked into our warehouse, how do I group together all the duplicates so all the quantities can be as one and the same product isn't showing multiple times? I will post a screenshot to show what I get and the code I'm using. Thanks

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'

Have you tried to use group by with sum ?

sgeddes
– sgeddes

2018-07-19 13:29:20 +00:00
Commented Jul 19, 2018 at 13:29 — sgeddes
– sgeddes, Commented Jul 19, 2018 at 13:29

L. Scott Johnson · Accepted Answer · 2018-07-19 13:32:56Z

2

sum and group by (and appropriate functions for any non-group-by expressions). e.g.,

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

answered Jul 19, 2018 at 13:32

L. Scott Johnson

4,4482 gold badges19 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Group together duplicates in Postgresql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related