mysql how to select maximum value of a column as another column in the resultset
<p>My table is like this  </p>

<pre><code>ID  VALUE  
1   4  
2   6  
3   12  
</code></pre>

<p>I want to get an output in this format in mysql, could you provide me with
an appropriate sql for the same  </p>

<pre><code>ID   VALUE  MAX_VALUE DIV_BY_MAX_VALUE  
1       4     12         0.33  
2       6     12         0.5   
3      12     12         1.0
</code></pre>