i want to remove dot(.) before decimal places in my amount value below is my database table
Query
SELECT sum( REPLACE( REPLACE( amt, ',', '' ) , ' ', '' ) )
FROM amt_demo
when i run above query i give me below output
Output
but i want total sum of value like
1333.00
100000.50
100000.00
123456789
123456789
123456789
---------------
370571700.50
any idea how can i solve this ? your all suggestions are appreciable
Aucun commentaire:
Enregistrer un commentaire