TechTip: Use SQL Columnar Functions for Statistics, Summing, and Counting

(Mike Faust) One thing that makes SQL such a powerful language is the ability to do statistical analysis and create a summary in a single SQL statement. This can be achieved through the use of aggregate or columnar functions, which allow you to create total- or subtotal-level summaries. Subtotal-lev

Read More - Register for Free Membership