How can i get end balance

You can use between in dates also, this will give you data between those dates + balance range of 10 to 100.

SELECT SUM(balance) AS 'No of Deposit'
FROM savta
WHERE prodid = 'S004'
AND tday  between '2014-10-01'  and '30-09-2014'
AND balance BETWEEN 10 AND  100

---

Tech