I have trouble with sql server select query. I have following table.
I want to select those record where the sum of Quantity < value. For example if I say select those record where the Quantity sum <65 then the output will be
because if we include the next record then the sum of Quantity will 75.
I want to create this query. Please help me out.