14-02-2021, Saat: 22:46
Merhaba kümülatif toplam alınarak yapılabılır
CREATE TABLE dbo.Cuzdan ( CuzdanId int IDENTITY(1, 1) NOT NULL, Tutar float DEFAULT 0 NULL, PRIMARY KEY CLUSTERED (CuzdanId) WITH ( PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ) ON [PRIMARY] GO INSERT INTO dbo.Cuzdan (CuzdanId, Tutar) VALUES (1, 100) GO CREATE TABLE dbo.Harcama ( Id int IDENTITY(1, 1) NOT NULL, KartNo varchar(20) COLLATE Turkish_CI_AS NULL, Zaman datetime NULL, CuzdanId int NULL, HarcamaTutari float NULL, PRIMARY KEY CLUSTERED (Id) WITH ( PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ) ON [PRIMARY] GO INSERT INTO dbo.Harcama (Id, KartNo, Zaman, CuzdanId, HarcamaTutari) VALUES (1, N'A', '20210214 12:00:00', 1, 5), (2, N'B', '20210214 15:00:00', 1, 2), (3, N'C', '20210214 18:00:00', 1, 3) GO /*SORGU*/ SELECT K.ID, K.KartNo, K.Zaman, K.HarcamaTutari, C.Tutar - ISNULL(SUM(K.HarcamaTutari) OVER(ORDER BY K.Zaman),0)+ ISNULL(K.HarcamaTutari,0) AS ONCEKI_TUTAR, C.Tutar - ISNULL(SUM(K.HarcamaTutari) OVER(ORDER BY K.Zaman),0) AS KALAN_TUTAR FROM Harcama AS K JOIN Cuzdan AS C ON C.CuzdanId=K.CuzdanId