FLOOR/de

From SQLZOO
< FLOOR
Revision as of 22:05, 21 October 2012 by Peter (Talk | contribs)

(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
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense