Function Description Example Count all rows Add 1 for each data Count employees row included in result Count all Add 1 for element Count of employees with a values value value for manager Total all Add the value for all Total employee salaries values element values Average all The total divided by Average employee salaries values the count of element values Maximum The largest Maximum salary value element value Minimum The smallest element Minimum salary value distinct Add 1 for each Count of different manager values different element values value Total distinct Add the for each Total of different salary values different element amounts value Average The divided by Average of different distinct values the count of different employee salaries element values The TOTAL, and AVERAGE DISTINCT VALUES functions will count, total, and average only unique values. For example, to count the number of projects with tasks you could use the COUNT DISTINCT VALUES function for the PROJ_NO element in the TASKS table.
Function Description Example Count all rows Add 1 for each data row included in result Count employees Count all values Add 1 for element value Count of employees with a value for manager Total all values Add the value for all element values Total employee salaries Average all values The total divided by the count of element values Average employee salaries Maximum value The largest element value Maximum salary Minimum The smallest element value Minimum salary distinct values Add 1 for each different element value Count of different manager values Total distinct values Add the for each different element value Total of different salary amounts Average distinct values The divided by the count of different element values Average of different employee salaries The TOTAL, and AVERAGE DISTINCT VALUES functions will count, total, and average only unique values. For example, to count the number of projects with tasks you could use the COUNT DISTINCT VALUES function for the PROJ_NO element in the TASKS table.
_new_ezq_reference.docx