New SQL user here, have a probably simple question about querying.
Is it possible to run a query that will "combine" rows containing the same value in a field and summing up another field for those rows?
Ex Say we have 3 fields - Order date, Sales Order #, Part Number, Line Price.
Sales Order# appears multiple times because there are more than one part number on a particular sales order.
I would want to query where it takes any sales order that is the SAME and it puts that in the table only once, and it sums up the line price (to give a total order price). The other fields could just be "Keep 1st" type thing. Is this possible?
I normally do this in excel but when I have tons of rows this doesn't cooperate very well.