title: Getting different results for Mysql round function when used in two different ways
body: <p>I have a column with only one column 'id'. The create statement of the table is:</p>
  
  <pre><code>CREATE TABLE `test` (
    `id` float default NULL
  );
  </code></pre>
  
  <p>The value present in the table is:</p>
  
  <pre><code>id
  -----
  8.075
  </code></pre>
  
  <p>When I execute the query:</p>
  
  <pre><code>SELECT ROUND(id, 2) FROM test;
  </code></pre>
  
  <p>I am getting result '8.07'.
  But when I simply execute the query:</p>
  
  <pre><code>SELECT ROUND(8.075,2);
  </code></pre>
  
  <p>I am getting value of '8.08'.</p>
  
  <p>What can be done to get the consistent result in both the cases?</p>
  
  <p>The demo of these query can be viewed <a href="http://sqlfiddle.com/#!2/256b6/2" rel="nofollow">here</a>.</p>