O'Reilly logo

Sams Teach Yourself ColdFusion® in 21 Days by Charles Mohnike

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Understanding Aggregate Functions

In Day 14, "Using ColdFusion Functions to Manipulate Data," you learned that ColdFusion has a special set of functions that can be used to modify variables or to display certain values, such as a time and date. SQL uses two types of functions: scalar and aggregate. You won't have to worry much about scalar functions because ColdFusion functions will perform the same tricks as SQL's scalar functions, but you'll find SQL's aggregate functions to be pretty useful tools.

Aggregate functions provide "data about the data" selected by SQL statements. That is, aggregate functions are used to report details about the records selected by a given SQL query.

To illustrate how SQL's aggregate functions are used, I added two ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required