Summing up 100 columns
138698Jul 26 2009 — edited Jul 27 2009Hi;
I have a table that has 100 columns, I want to sum 96 columns and do group by.
I want to do,
select col1, col2, col3, sum(col4+col5+col6+.....+col100) from tableA group by col1, col2, col3.
I do not want to give all 96 column names, what is the best way to do it?
Regards,