Connor at 15:24, 16 July 2012

2012-07-16T15:24:13Z

Connor: Created page with "
Compatibility
ROUND(f,p)

'''Engine''' '''OK'''<..."
2012-07-16T09:59:48Z

Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>ROUND(f,p)</th></tr> <tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''<..."

New page
<table align='right' border='1'>
<caption>Compatibility</caption>
<tr><th colspan='3'>ROUND(f,p)</th></tr>
<tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr>
<tr><td align='left'>ingres</td><td>Yes</td><td></td></tr>
<tr><td align='left'>mysql</td><td>Yes</td><td></td></tr>
<tr><td align='left'>oracle</td><td>Yes</td><td></td></tr>
<tr><td align='left'>postgres</td><td>Yes</td><td></td></tr>
<tr><td align='left'>sqlserver</td><td>Yes</td><td></td></tr>
</table>
<h1>ROUND</h1>
<p>ROUND(f,p) returns f rounded to p decimal places.</p>
<p>The number of decimal places may be negative, this will round to the nearest 10 (when p is -1) or 100 (when p is -2) or 1000 (when p is -3) etc.. </p>
<pre style='width:50ex'>
ROUND(2.7,0) -> 3
ROUND(2.71,1) -> 2.7
</pre>

<div class='qu'>
In this example we calculate the population in millions to one demial place.
<source lang='sql' class='def'>
SELECT name,
ROUND(population/1000000,1)
FROM bbc
</source>
</div>

<p>See also</p>
<ul>
<li>[[FLOOR |FLOOR function]]</li>
<li>[[CEIL function]]</li>
<li>[[MOD |MOD function]]</li>
</ul>

@@ Line 29: / Line 29: @@
 <ul>
    <li>[[FLOOR |FLOOR function]]</li>
-   <li>[[CEIL function]]</li>
+   <li>[[CEIL |CEIL function]]</li>
    <li>[[MOD |MOD function]]</li>
 </ul>