1.12 Determining the maximum, minimum, average, or sum of the retrieved data (set functions)

Use the set functions MAX, MIN, AVG, and SUM to determine the maximum value, minimum value, average, or sum of the retrieved data.

Note

For details about the syntax of set functions, see 7.22 Set functions.

Organization of this section

• 1.12.1 Example 1: Determine the maximum, minimum, and average quantities purchased

• 1.12.2 Example 2: Determine the sum of quantities purchased)

To Page Top