title: Aggregate function SUM() for money
body: <p>Requirement is add salary of employee i m using SUM() , salary is in this format <code>1,00,005.00</code> so when <code>1,00,005.00 + 3,00,005.00</code> it gives result as 4 not actual result , 
  this is query ----></p>
  
  <pre><code>SELECT employee.name, SUM( department.salary ) AS Salary
   FROM department
   LEFT JOIN employee ON department.employee_id = employee.id
   GROUP BY name
  </code></pre>