<div>
;WITH &nbsp; NumberedRows 
AS 
( 
&nbsp; &nbsp; SELECT &nbsp;rta.*, row_number() OVER (ORDER BY rta.ID ASC) AS RowNumber 
&nbsp; &nbsp; FROM &nbsp; &nbsp;test10k rta 
) 
 
SELECT &nbsp;nr.ID, nr.Number, 
&nbsp; &nbsp; avg(trailing.Number) as MovingAverage 
FROM &nbsp; &nbsp;NumberedRows nr 
&nbsp; &nbsp; join NumberedRows as trailing on trailing.RowNumber between nr.RowNumber-3 and nr.RowNumber-1 
where nr.Number &gt;&nbsp;3 
group by nr.id, nr.Number 
 
Ref. <a href="https://stackoverflow.com/questions/911326/sql-select-statement-for-calculating-a-running-average-column" rel="ugc">https://stackoverflow.com/questions/911326/sql-select-statement-for-calculating-a-running-average-column</a>
</div>

;WITH   NumberedRows
AS
(
    SELECT  rta.*, row_number() OVER (ORDER BY rta.ID ASC) AS RowNumber
    FROM    test10k rta
)

SELECT  nr.ID, nr.Number,
    avg(trailing.Number) as MovingAverage
FROM    NumberedRows nr
    join NumberedRows as trailing on trailing.RowNumber between nr.RowNumber-3 and nr.RowNumber-1
where nr.Number > 3
group by nr.id, nr.Number

Ref. https://stackoverflow.com/questions/911326/sql-select-statement-for-calculating-a-running-average-column [https://stackoverflow.com/questions/911326/sql-select-statement-for-calculating-a-running-average-column]

<div>
<div class="content wysiwyg-content">
I have a table with dates in one column and total in the second one 
 
Date &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Total 
01-Jan-15 &nbsp; &nbsp; &nbsp;5 
02-Jan-15 &nbsp; &nbsp; &nbsp;4 
03-Jan-15 &nbsp; &nbsp; &nbsp;3 
04-Jan-15 &nbsp; &nbsp; &nbsp;12 
05-Jan-15 &nbsp; &nbsp; &nbsp;14 
06-Jan-15 &nbsp; &nbsp; &nbsp;7 
07-Jan-15 &nbsp; &nbsp; &nbsp;9 
 
I want to run a query that will return a trailing two day average. &nbsp;it should return the following 
 
01-Jan-15 &nbsp; &nbsp; &nbsp; 
02-Jan-15 &nbsp; &nbsp; &nbsp; &nbsp;4.5 
03-Jan-15 &nbsp; &nbsp; &nbsp; &nbsp;3.5 
04-Jan-15 &nbsp; &nbsp; &nbsp; &nbsp;7.5 
05-Jan-15 &nbsp; &nbsp; &nbsp;13 
06-Jan-15 &nbsp; &nbsp; &nbsp;10.5 
07-Jan-15 &nbsp; &nbsp; &nbsp; &nbsp;8
</div>
</div>

I have a table with dates in one column and total in the second one

Date            Total
01-Jan-15      5
02-Jan-15      4
03-Jan-15      3
04-Jan-15      12
05-Jan-15      14
06-Jan-15      7
07-Jan-15      9

I want to run a query that will return a trailing two day average.  it should return the following

01-Jan-15       
02-Jan-15        4.5
03-Jan-15        3.5
04-Jan-15        7.5
05-Jan-15      13
06-Jan-15      10.5
07-Jan-15        8

SQL select trailing two day average

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.