• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Day 19. Using Advanced SQL Techniques > Understanding Aggregate Functions

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint