Hi ALL,
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