on 01-20-2021 3:04 PM
In my case, I am looking to sum the values in "Disposals_CC3" column and display as a single value.
Any suggestions on doing this would be helpful.
Thanks,
Sab
You need yo use GROUP BY operator and list there all attributes, and for measures add SUM as an aggregation function.
SELECT
<List all attribute columns separated by comma>
,SUM("Disposals_CC3")
FROM
table
GROUP BY
<List all attribute columns separated by comma>
For example:
SELECT
TXK50
,KTOPL
,SUM("Disposals_CC3")
FROM
table
GROUP BY
TXK50
,KTOPL
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.