What is an aggregate function?
Answer: To aggregate means to put together or combine. An aggregate function, therefore, performs a calculation on the values in a column and returns a single (combined) value, such as a count or an average. Examples of using this type of function are as follows:
?Finding the sum (total) values in a column. Example: the total amount contributed to a specific fund.
?Obtaining a count of a set of records. Example: the total number of 18-year-old members in an organization.
?Determining the average value in a column. Example: the average dollar amount of pledges made to a specific fund.
?Finding the lowest value in a column. Example: the lowest contribution amount made to a specific fund.
?Finding the highest value in a column. Example: the oldest member in your organization.
In each example, all you want is a summary of the column's data—not the column's actual data. Therefore, the query result is always equal to 1.
You might also like to view...
Pointers cannot be used to:
a. Contain memory addresses. b. Reference values directly. c. Pass an argument by reference. d. Manipulate dynamic data structures.
A(n) __________ is a standard way to draw diagrams that describe object-oriented systems.
a. data flow diagram b. UML diagram c. pseudocode representation d. hierarchy chart
A list of links to Web sites that you have saved is called:
A) History B) Recent Pages C) Favorites Center D) Temporary Internet files
Which of the following is NOT true in regard to selecting the appropriate macro setting?
A) The most common settings are Disable all macros with notification and Disable all macros except digitally signed macros. B) Settings can help to mitigate the risk of a macro virus and still allow useful macros to run. C) Depending on the nature of the organization, the policy may be to disable all macros. D) If the database is in a location defined as a Trusted Location, the macros will not be ignored by the Trust Center security system.