title: Subtraction in SQL Server up to 3 decimal places
body: <p>I have table <code>P</code> in a SQL Server database.</p>
  
  <p>In table <code>P</code>, I have a value 234.6 in column A and 234.595 in column B. </p>
  
  <p>A query </p>
  
  <pre><code>select A-B 
  from P
  </code></pre>
  
  <p>yields the result </p>
  
  <pre><code>0.004999999999545
  </code></pre>
  
  <p>It ideally should be </p>
  
  <pre><code>0.005
  </code></pre>
  
  <p>What should I do to get result as 0.005?</p>