How can I sum a column as an expression?
Posted on 2010-11-15
In my VarChar Column, 'ZZ', I have 3 possibilities with a total of 134 rows :
I need to create a table to show a total of each of these possibilities that are listed.
aaaa bbbb cccc
53 47 34 TOTAL
Please provide an expression that I can use to obtain each of the 3 totals.