http://www.sqlzoo.net/w/index.php?title=CEIL&feed=atom&action=history
CEIL - Revision history
2013-05-20T12:32:30Z
Revision history for this page on the wiki
MediaWiki 1.20.4
http://www.sqlzoo.net/w/index.php?title=CEIL&diff=4112&oldid=prev
Peter at 09:57, 1 October 2012
2012-10-01T09:57:49Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 09:57, 1 October 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 13:</td>
<td colspan="2" class="diff-lineno">Line 13:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>CEIL(f) give the integer that is equal to, or just higher than f. CEIL always rounds up.</p>  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>CEIL(f) give the integer that is equal to, or just higher than f. CEIL always rounds up.</p>  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><pre style='width:50ex'></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><pre style='width:50ex'></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>  CEIL(2.7)  ->  <del class="diffchange diffchange-inline">2</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>  CEIL(2.7)  ->  <ins class="diffchange diffchange-inline">3</ins></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>  CEIL(-2.7) -> -<del class="diffchange diffchange-inline">3</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>  CEIL(-2.7) -> -<ins class="diffchange diffchange-inline">2</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></pre></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></pre></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
</table>
Peter
http://www.sqlzoo.net/w/index.php?title=CEIL&diff=4111&oldid=prev
Peter at 09:51, 1 October 2012
2012-10-01T09:51:13Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 09:51, 1 October 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 36:</td>
<td colspan="2" class="diff-lineno">Line 36:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[[MOD |MOD function]]</li></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[[MOD |MOD function]]</li></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">{{Languages}}</ins></div></td></tr>
</table>
Peter
http://www.sqlzoo.net/w/index.php?title=CEIL&diff=1349&oldid=prev
Connor at 14:37, 16 July 2012
2012-07-16T14:37:40Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 14:37, 16 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 20:</td>
<td colspan="2" class="diff-lineno">Line 20:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>In this example we calculate the population in millions.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>In this example we calculate the population in millions.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-sqlserver'>  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-sqlserver'>  </div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>SELECT <del class="diffchange diffchange-inline">name</del>,</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>SELECT <ins class="diffchange diffchange-inline">population/1000000 AS a</ins>,</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>       FLOOR(population/1000000)</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>       FLOOR(population/1000000) <ins class="diffchange diffchange-inline">AS b</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   FROM bbc</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   FROM bbc</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td></tr>
</table>
Connor
http://www.sqlzoo.net/w/index.php?title=CEIL&diff=1282&oldid=prev
Connor at 10:06, 16 July 2012
2012-07-16T10:06:13Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 10:06, 16 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 23:</td>
<td colspan="2" class="diff-lineno">Line 23:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>       FLOOR(population/1000000)</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>       FLOOR(population/1000000)</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   FROM bbc</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   FROM bbc</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></source></ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def'></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def'></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT population/1000000 AS a,</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT population/1000000 AS a,</div></td></tr>
</table>
Connor
http://www.sqlzoo.net/w/index.php?title=CEIL&diff=1281&oldid=prev
Connor: Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>CEIL(f)</th></tr> <tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td..."
2012-07-16T10:05:53Z
<p>Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>CEIL(f)</th></tr> <tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td..."</p>
<p><b>New page</b></p><div><table align='right' border='1'><br />
<caption>Compatibility</caption><br />
<tr><th colspan='3'>CEIL(f)</th></tr><br />
<tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr><br />
<tr><td align='left'>ingres</td><td>Yes</td><td></td></tr><br />
<tr><td align='left'>mysql</td><td>Yes</td><td></td></tr><br />
<tr><td align='left'>oracle</td><td>Yes</td><td></td></tr><br />
<tr><td align='left'>postgres</td><td>Yes</td><td></td></tr><br />
<tr><td align='left'>sqlserver</td><td>No</td><td>[[FLOOR |FLOOR(-f)]]</td></tr><br />
</table><br />
<h1>CEIL</h1><br />
<p>CEIL(f) is ceiling, it returns the integer that is equal to or just more than f</p><br />
<p>CEIL(f) give the integer that is equal to, or just higher than f. CEIL always rounds up.</p> <br />
<pre style='width:50ex'><br />
CEIL(2.7) -> 2<br />
CEIL(-2.7) -> -3<br />
</pre><br />
<br />
<div class='ht'><br />
In this example we calculate the population in millions.<br />
<source lang='sql' class='def e-sqlserver'> <br />
SELECT name,<br />
FLOOR(population/1000000)<br />
FROM bbc<br />
<source lang='sql' class='def'><br />
SELECT population/1000000 AS a,<br />
CEIL(population/1000000) AS b<br />
FROM bbc<br />
</source><br />
</div><br />
<br />
<p>See also</p><br />
<ul><br />
<li>[[ROUND |ROUND function]]</li><br />
<li>[[MOD |MOD function]]</li><br />
</ul></div>
Connor