I Have data types of table dbo.coba as following :
I want SUM and group by from query as following :
But, when I exec query as :
select
nama,
SUM(CAST(REPLACE(jumlah, ',','') AS bigint))
from
dbo.coba
group by nama, jumlah
and result :
My hope is that each name produces a total number of them all by group by name and the number becomes one group, please help me
[4]: /answers/storage/attachments/132018-convert-from-replace-varchar-to-int-and-then-sum.png