Retrieve the largest integer that is not greater than a specified value: FLOOR() : FLOOR « Math « SQL / MySQL






  1. SQL / MySQL
  2. Math
  3. FLOOR

Retrieve the largest integer that is not greater than a specified value: FLOOR()

      
mysql>
mysql> SELECT FLOOR(9.327);
+--------------+
| FLOOR(9.327) |
+--------------+
|            9 |
+--------------+
1 row in set (0.00 sec)

mysql>








Related examples in the same category

1.Use FLOOR( ) if you prefer integer values to floating-point values:
2.Try multiplying the FLOOR( ) results by five:
3.get Pi and round it up and down
4.To put each population value in the proper category, divide by five million and use the integer result