CEIL/de - Revision history

Peter at 17:09, 21 October 2012

2012-10-21T17:09:55Z

Peter at 17:08, 21 October 2012

2012-10-21T17:08:56Z

Peter: Created page with "Category:Deutsch
Kompatibilität
CEIL(f)

'''DBMS'''
2012-10-01T09:59:03Z

Created page with "Category:Deutsch <table align='right' border='1'> <caption>Kompatibilität</caption> <tr><th colspan='3'>CEIL(f)</th></tr> <tr><td align='center'>'''DBMS'''</td><td align=..."

New page
[[Category:Deutsch]]
<table align='right' border='1'>
<caption>Kompatibilität</caption>
<tr><th colspan='3'>CEIL(f)</th></tr>
<tr><td align='center'>'''DBMS'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr>
<tr><td align='left'>Ingres</td><td>Ja</td><td></td></tr>
<tr><td align='left'>MySQL</td><td>Ja</td><td></td></tr>
<tr><td align='left'>Oracle</td><td>Ja</td><td></td></tr>
<tr><td align='left'>PostgreSQL</td><td>Ja</td><td></td></tr>
<tr><td align='left'>SQL Server</td><td>Nein</td><td>[[FLOOR |FLOOR(-f)]]</td></tr>
</table>

<h1>CEIL</h1>
<p><b>CEIL(f)</b> ermittelt die Ganzzahl (Integer), die gleich oder die nächstgrößere Zahl zu <b>f</b> ist. CEIL rundet immer auf.</p>
<pre style='width:50ex'>
CEIL(2.7) -> 3
CEIL(-2.7) -> -2
</pre>

<div class='ht'>
In diesem Beispiel wird die Bevölkerungszahl (Population) in Millionen berechnet.
<source lang='sql' class='def e-sqlserver'>
SELECT population/1000000 AS a,
FLOOR(population/1000000) AS b
FROM bbc
</source>
<source lang='sql' class='def'>
SELECT population/1000000 AS a,
CEIL(population/1000000) AS b
FROM bbc
</source>
</div>

<p>Siehe auch</p>
<ul>
<li>[[ROUND | Funktion ROUND]]</li>
<li>[[MOD | Funktion MOD]]</li>
</ul>

{{Languages}}