SQL for Analytics Developer Guide
j
No Results
Search Tips:
- Please consider misspellings
- Try different search keywords
floor(n)
Returns the nearest integer of equal or lesser value to n. n can be any real numeric
value in the range of -1.797e308<= n <= 1.797e308.
floor(n) takes the following syntax.
SELECT floor(column_name) as AliasName
FROM dataset;Example
This example returns values in the Discount field rounded down to the nearest integer. In the first three rows, the Discount value is 0. The fourth and fifth values are 0.45 and 0.2, respectively, which are rounded to 0.
SELECT floor(Discount) as floorDiscount
FROM Superstore
LIMIT 5;| floorDiscount |
|---|
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |