reduce rows

Question

reduce rows

arkiboys 9,706

hi,
see screen-shot below:
Question
how is it possible to achieve the result in green from the data in orange colour. -

Answer accepted by question author

0 additional answers

Your answer

Answer 1

Viorel 125.8K

Try something like this:

select ID, book, dispatch, arrival, company, sum(p_value) as p_value, sum(a_value) as a_value  
from OrangeTable  
group by ID, book, dispatch, arrival, company

arkiboys 9,706 Reputation points

2022-08-16T08:12:12.59+00:00

is it possible/best to do this using inner join?

Viorel 125.8K

Using join:

select t1.ID, t1.book, t1.dispatch, t1.arrival, t1.company, t1.p_value, t2.a_value  
from OrangeTable t1  
inner join OrangeTable t2 on t1.ID = t2.ID and t1.book = t2.book and t1.dispatch = t2.dispatch and t1.arrival = t2.arrival and t1.company = t2.company  
where t1.p_value is not null and t2.a_value is not null

Share via

reduce rows

0 additional answers

Your answer