Explain how an aggregate function differs from a calculated field
What will be an ideal response?
An aggregated function is a calculation that returns a single value, calculated from multiple values in a column. Common aggregate functions include Average, Count, Maximum, Median, Minimum, Mode, and Sum.
How an aggregated function differs from a calculated field is that when you create a calculated field, you are calculating or summarizing data across a single row at a time. However, when you create an aggregated field, you are calculating or summarizing data across entire groups of rows. The word aggregate simply means a summative calculation, such as a total or average, or summarizing data.
You might also like to view...
A risk manager requires that his organization implement a control to prevent application attacks. The best solution is to use:
a. Multi-tier architecture b. Code reviews c. An application vulnerability scanner d. An application firewall
We take a sample of adults and measure their heights. If we record the gender of each person, we can calculate the average height and the variance of the height, separately, for men and women. Suppose, however, that this informa- tion was not recorded. Would it be possible to still obtain this information? Explain.
What will be an ideal response?