FLOOR/de

From SQLZOO
< FLOOR
Revision as of 21:05, 21 October 2012 by Peter (Talk | contribs) (Created page with "Category:Deutsch <table align='right' border='1'> <caption>Kompatibilität</caption> <tr><th colspan='3'>FLOOR(f)</th></tr> <tr><td align='center'>'''DBMS'''</td><td align...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
Kompatibilität
FLOOR(f)
DBMSOKAlternative
IngresJa
MySQLJa
OracleJa
PostgreSQLJa
SQL ServerJa

FLOOR

FLOOR(f) liefert den Integer-Wert, der gleich oder kleiner f ist. FLOOR rundet ab.

  FLOOR(2.7) ->  2
  FLOOR(-2.7) -> -3

In diesem Beispiel wird die Bevölkerungszahl je Land in Millionen ermittelt.

SELECT name,
       FLOOR(population/1000000)
  FROM bbc

Siehe auch

Sprache: English  • Deutsch