CODEWITHSUNDEEP
oracle-databasesqlplus
kpAtCh
kpAtCh

Reputation: 107

SQL Getting the total or sum of a column

So here's the query that I currently have.

`SELECT war.id, inv.pro_id, inv.quantity
FROM L4_Warehouses war, L4_Inventories inv, L4_Employees emp, L4_Orders ord
WHERE inv.war_id = war.id AND
      war.id = emp.war_id AND
      emp.id = ord.emp_id AND
      ord.status = 'P'
ORDER BY inv.war_id, inv.pro_id;`

this query gives this table.

enter image description here

Now, what I want to get for the final result is to get the sum of those Quantities, example below

ID      PRO_ID      QUANTITY
1       100         18
1       101         6
1       110         6

Upvotes: 0

Views: 46

Answers (1)

TrevorBrooks
TrevorBrooks

Reputation: 3840

Try SUM and GROUP BY: 

SELECT war.id, inv.pro_id, SUM(inv.quantity)
FROM L4_Warehouses war, L4_Inventories inv, L4_Employees emp, L4_Orders ord
WHERE inv.war_id = war.id AND
      war.id = emp.war_id AND
      emp.id = ord.emp_id AND
      ord.status = 'P'
GROUP BY war.id, inv.pro_id
ORDER BY inv.war_id, inv.pro_id;

Upvotes: 1

Related Questions