register
login
shopping cart
0 items in cart
Tweet
function libraries, tools and services for Microsoft SQL Server
Contact Us
Support
NoSQL vs SQL
Purchase
Download
Products
Home
SQLUtilities
SQLFinancials
SQLStatistics
SQLRollingStats
SQLMath
SQLEngineering
SQLDistributions
SQLFile
SQLTuples
Assembly Manager
Bespoke Assemblies
Data Migration
Data Cleansing
Database Design
Business Intelligence
Application Design
Features
Overview
Pricing
Documentation
SQLRollingStats
Running totals & moving averages on the fly
without jumping through hoops
Edit
31 scalar functions that return results based on data from current row and prior rows in the
same
query.
All functions support a rolling window that discards older values, or can be cumulative (no window).
All functions support tiling (accumulation of data restarts when input row number restarts from 1).
All functions provide checking & enforcement of row-processing order using row number inputs.
Sum and product
.
Maximum, minimum, range and mid-range
.
First (for a window size of
n
will return input from
n
rows ago) and Previous (value from prior row) .
Average (mean), sample & population variance, sample & population standard deviation. .
Geometric mean, harmonic mean, quadratic mean.
.
Weighted
average, sample & population variance, sample & population standard deviations. .
Exponentially
weighted
average, variance and standard deviations. .
Weighted power mean (generalized mean).
.
Median, quartile, inter-quartile range, tri-mean.
.
Percentile & percentile rank.
.
Request Callback
Buy Online
Download Trial
Talk to Us
Next Steps:
My Account
Privacy Policy
Terms of Use
Partners