Monthly Archives: September 2014

What is the Difference between ROWS and RANGE?

Posted on 2014/09/27 by Kathi Kellenberger

UPDATE: For more from me about T-SQL Window Functions, check out my Pluralsight course! I have been speaking and writing a bunch lately on T-SQL window functions. There is always more to learn, it seems. Framing for many of the … Continue reading →

Posted in T-SQL, T-SQL Window Functions | 3 Comments

How to Use a Window Aggregate in an Aggregate Query

Posted on 2014/09/23 by Kathi Kellenberger

A window aggregate function is an easy way to perform an aggregate calculation without changing the query to an aggregate query. This means that you can calculate an aggregate over the entire dataset while keeping the detail in the results. … Continue reading →

Posted in T-SQL, T-SQL Window Functions | Leave a comment