Each service has the same price and ID. In final table I would sum quantity of the same rows – each service appear only one time and complete ID and price.
I created example table https://dbfiddle.uk/Z1EQca0b
and I can only return service name and quantity
SELECT Service_name, SUM (Qty) As Sum
FROM NewOne
GROUP BY Service_Name
Value is the result of multiplying qty and price
My table:
| ID | Service_Name | Price | Qty | Value | Ident | Where |
|---|---|---|---|---|---|---|
| 1 | Repair | 123.6000000000 | 5 | 618.0 | 123A | London |
| 2 | Collect | 120.1000000000 | 4 | 480.4 | 127B | Paris |
| 3 | Buy | 100.1000000000 | 14 | 1401.4 | 130C | Paris |
| 4 | Repair | 123.6000000000 | 5 | 618.0 | 123A | Paris |
| 5 | Collect | 120.1000000000 | 9 | 1080.9 | 127B | Rome |
| 6 | Buy | 100.1000000000 | 12 | 1201.2 | 130C | Rome |
| 7 | Collect | 120.1000000000 | 15 | 1801.5 | 127B | London |
| 8 | Buy | 100.1000000000 | 1 | 100.1 | 130C | London |
My expectations after query
| Service_Name | Price | Qty | Value | Ident |
|---|---|---|---|---|
| Repair | 123.6000000000 | 10 | 1236.0 | 123A |
| Collect | 120.1000000000 | 28 | 3362.8 | 127B |
| Buy | 100.1000000000 | 27 | 2702.7 | 130C |
You need to sign in to view this answers
