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