Gjoreski |
20.08.2018 11:44 |
Predmet:Komulativni zbir
Verzija 1
PreuzmiIzvorni kôd (SQL):SELECT t1.DayCount, t1.Sales, SUM(t2.Sales) AS suma
FROM dbo.Sales t1
INNER JOIN Sales t2 ON t1.DayCount >= t2.DayCount
GROUP BY t1.DayCount, t1.Sales
ORDER BY t1.DayCount
Verzija 2
PreuzmiIzvorni kôd (SQL):DECLARE @SalesTbl TABLE (DayCount SMALLINT, Sales money, RunningTotal money)
DECLARE @DayCount SMALLINT,
@Sales money,
@RunningTotal money
SET @RunningTotal = 0
DECLARE rt_cursor CURSOR
FOR
SELECT DayCount, Sales
FROM tSales
ORDER BY DayCount
OPEN rt_cursor
FETCH NEXT FROM rt_cursor INTO @DayCount,@Sales
WHILE @@FETCH_STATUS = 0
BEGIN
SET @RunningTotal = @RunningTotal + @Sales
INSERT @SalesTbl VALUES (@DayCount,@Sales,@RunningTotal)
FETCH NEXT FROM rt_cursor INTO @DayCount,@Sales
END
CLOSE rt_cursor
DEALLOCATE rt_cursor
SELECT * FROM @SalesTbl
|