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