SQLRollingStats 1.0.0.0
Free Trial Version
Publisher Description
SQLRollingStats extends the T-SQL scripting environment with 31 windowed or cumulative functions (in which results for each row depend on previous rows) that can be used as regular functions in queries.
This allows metrics such as running totals or moving averages to be easily calculated within simple queries - something that has hitherto been a significant challenge in SQL Server.
All the functions support windowing (such that only values from the last n rows are included in the input set - where n is the window size), cumulative operation (where all prior values are counted), and tiling (so the accumulation is restarted for each distinct value of a given column).
Functions include:
- Sum, product, maximum, minimum, range, mid-range, first (in sequence), nth previous.
- Average (mean), variance (sample & population), standard deviation (sample & population).
- Geometric mean, harmonic mean, quadratic mean.
- Median, quartile, inter-quartile range, tri-mean, percentile, percentile rank.
- Exponential average (mean), exponential variance, exponential standard deviation.
- Weighted average, weighted variance (sample & population), weighted standard deviation (sample & population), weighted power mean.
About SQLRollingStats
SQLRollingStats is a free trial software published in the Components & Libraries list of programs, part of Development.
This Components & Libraries program is available in English. It was last updated on 22 April, 2024. SQLRollingStats is compatible with the following operating systems: Windows.
The company that develops SQLRollingStats is TotallySQL Ltd. The latest version released by its developer is 1.0.0.0. This version was rated by 1 users of our site and has an average rating of 4.0.
The download we have available for SQLRollingStats has a file size of . Just click the green Download button above to start the downloading process. The program is listed on our website since 2011-05-03 and was downloaded 95 times. We have already checked if the download link is safe, however for your own protection we recommend that you scan the downloaded software with your antivirus. Your antivirus may detect the SQLRollingStats as malware if the download link is broken.
How to install SQLRollingStats on your Windows device:
- Click on the Download button on our website. This will start the download from the website of the developer.
- Once the SQLRollingStats is downloaded click on it to start the setup process (assuming you are on a desktop computer).
- When the installation is finished you should be able to see and run the program.
