Group By and SUM in SQL


Could someone help me out, I am trying to sum one column as per the repetative id and I dont need only them in result but whole table.

select *, sum(columnname) from table group by repetative id

the above query will not work as I have to aggregate or group by other column of table as well