Query to calculate Quantity on Hand

Question

i want to calculate the quantity when the product is sale that come in stock table with product_id and quantity add in stock_out

and when the purchase then quantity add in Stock_in can u plz tell me how to make the query to know the quantity

SELECT TOP 1000 [id]

,[product_id]
,[stock_date]
,[stock_in]
,[stock_out]
,[vocher_type]
,[vocher_id]
FROM [OnlineTradingFinal].[dbo].[Stock]

Joginder Banger · Answer

I assume your stock table is like that stock table. Column Name .... ID Product_id Quantity In Stock table have values like 110150 210260 310110 410220 select Product_ID count(Quantity) from stock_table_name group by Product_id. as per expected results : 10160 10280