Create Table tbla
(
Prodname varchar(20),
ProdDate date,
Plusamt decimal(18,2),
Minuamt decimal(18,2)
)
Insert into tbla VALUES('Mouse','02/02/1981',300,0)
Insert into tbla VALUES('Mouse1','03/02/1981',0,100)
Insert into tbla VALUES('Mouse2','04/02/1981',1400,0)
Insert into tbla VALUES('Mouse3','05/02/1981',0,1000)
Insert into tbla VALUES('Mouse4','06/02/1981',2000,100)
SELECT * from Tbla
-- so for My output Query this
ProdName Date Plusamt Minusamt
Mouse 1981-02-02 300.00 0.00
Mouse1 1981-03-02 0.00 100.00
Mouse2 1981-04-02 1400.00 0.00
Mouse3 1981-05-02 0.00 1000.00
Mouse4 1981-06-02 2000.00 100.00
-- But I nee this output
-- My select Query date parameters
-- From date 04-02-1981 to 06-02-1981
ProdName Date Plusamt Minusamt Total
Mouse2 1981-04-02 1400.00 0.00 1400
Mouse3 1981-05-02 0.00 1000.00 400
Mouse4 1981-06-02 2000.00 100.00 2300
Mark as Answer if its helpful to you
Kumaraspcode2009@gmail.com