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 ...
Get Sams Teach Yourself ColdFusion® in 21 Days 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.
