Use SQL Columnar Functions for Statistics, Summing, and Counting by Mike Faust

The following link may require a free, or paid, registration to view the tip.

http://www.mcpressonline.com/tips-techniques/sql/techtip-use-sql-columnar-functions-for-statistics-summing-and-counting.html

[report a broken link by clicking here]