Aggregate Functions - Amazon Simple Storage Service
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China.

Aggregate Functions

Amazon S3 Select supports the following aggregate functions.

Function Argument Type Return Type
AVG(expression) INT, FLOAT, DECIMAL DECIMAL for an INT argument, FLOAT for a floating-point argument; otherwise the same as the argument data type.
COUNT - INT
MAX(expression) INT, DECIMAL Same as the argument type.
MIN(expression) INT, DECIMAL Same as the argument type.
SUM(expression) INT, FLOAT, DOUBLE, DECIMAL INT for INT argument, FLOAT for a floating-point argument; otherwise, the same as the argument data type.