C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML
MySQL FLOOR() FunctionThe floor() is a Math function of MySQL. This function is used to find the greatest integer which is equal to or less than the given number. Syntaxselect floor(number); ParameterNumber : It is the number to find the greatest integer. ReturnsThis function returns the largest integer value that is equal to or less than a number. Example 1Select floor(11.2); Output: Example 2Select floor(11.5); Output: Example 3Select floor(-11.5); Output:
Next TopicMySQL Math
|