title: SQL Real vs Float
body: <p>Let's say I have the following 2 queries:</p>
  
  <pre><code>select sum(cast(2666 as float)) * cast(.3 as float)
  select sum(cast(2666 as real)) * cast(.3 as real)
  </code></pre>
  
  <p>The 1st query returns: <code>799.8</code><br>
  The 2nd query returns: <code>799.800031781197</code></p>
  
  <p>Why does the 2nd query not return the same thing as the 1st?</p>