Aggregate array of integers index basic

[madhanmetalimits]

i have a column name mtd that value will be an array of integers like this [ 1, 2, 12, 11, 47, 23, 23, 26, 45, 16, 39, 27, 3, 30, 20, 34, 20, 42, 16, 37, 47, 44, 6, 40, 8 ], here I need to aggregate this array of integers for all the row's in that table, I have a filter option also so I can't able to create a separate view, based on the filter value need to aggregate this array, can I get how to write a query for this requirement.