Sum¶
Basic information¶
| Object type | functions.Sum | 
| Since | 0.1.0 | 
| Dialects | MySQL MariaDB PostgreSQL | 
Object attributes¶
| Attribute | Accepts | Required | 
|---|---|---|
| obj | functions.Sum | 
True | 
| property | functions.* Property CastOperator | 
True | 
| alias | String | False | 
JSON format¶
{
  "obj": "functions.Sum",
  "property": {
    "obj": "properties.Property",
    "name": "transactions.amount"
  },
  "alias": "total_amount"
}
SQL¶
SUM(transactions.amount) AS total_amount