Hi,
Can any one give me query to insert data
I have a table A with
col1 col2
A 3.2
B 2.3
C 12.8
D 34.27
A 5.4
B 12.2
C 7
D 24
I want to insert into a temporary table B
the distinct values of Table A col1 and sum(col2)
Table B
col1 col2
A 8.6
B 14.5
C 19.8
D 58.27
Thanks