# FLOOR

From SQLZOO

FLOOR(f) | ||
---|---|---|

Engine | OK | Alternative |

ingres | Yes | |

mysql | Yes | |

oracle | Yes | |

postgres | Yes | |

sqlserver | Yes |

# FLOOR

FLOOR(f) returns the integer value of f

FLOOR(f) give the integer that is equal to, or just less than f. FLOOR always rounds down.

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

In this example we calculate the population in millions.

```
SELECT name,
FLOOR(population/1000000)
FROM bbc
```

See also

Language: |
• DeutschEnglish |
---|