Chapter 5. Computing Aggregates

After completing this chapter, you will be able to:

  • Use aggregate functions in your applications to return totals and other summarizations from your data

  • Use these functions to improve performance and enhance features of your applications

  • Use CLR (common language runtime) aggregate functions to perform specialized calculations

In Part I of this book you learned how to design and build your database, to secure your database against unauthorized use and against unforeseen data loss, and to transfer your data to other locations. In Part II we’ll look at how to manipulate the data in your database, starting in this chapter with how to compute totals and other summary information about data in a table.

Read this chapter ...

Get Microsoft® SQL Server™ 2005: Applied Techniques Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.