sql - MySQL: Sum if rows are equal -


i want make sql select-query select everything, when client, thickness , material same value of 'amount' should added.

how go creating such query?

data sample

if understand correctly. this:

select     client,      thickness,     material,     sum(amount) totalamount     table1 group     client,      thickness,     material  

Comments

Popular posts from this blog

matlab - "Contour not rendered for non-finite ZData" -

delphi - Indy UDP Read Contents of Adata -

javascript - Any ideas when Firefox is likely to implement lengthAdjust and textLength? -