There is a table like: Table:x PN|Feb_1|Feb_2|Feb_3|Feb_4 A|2|3|4|5 B|3|4|5|6 The result table I wanted is like: PN|Feb_1|Feb_2|Feb_3|Feb_4|Total A|2|3|4|5|14 B|3|4|5|6|18 The column "Total" is the summary of columns(Feb_1,Feb_2,Feb_3,Feb_4). Is there a sql text that can accomplish that? I mean not to add it one by one such as "select pn,Feb_1,Feb_2,Feb_3,Feb_4,(Feb_1+Feb_2+Feb_3+Feb_4) Total from A" I wonder if there is a function that can add columns value by giving the column id. "sum(2 to 4)" or something like that. I just what to offer the column ids.