SQL FLOOR Function

The SQL FLOOR function is one of the SQL Server Mathematical Function which is used to return the closest integer value which is less than or equal to the specified expression or Value.

SQL Server FLOOR Function Syntax

The basic syntax of the SQL Server Floor Function is:

In this article we will show you, How to write FLOOR Function in SQL Server with example. For this, We are going to use the below shown data

SQL FLOOR() Function Example 1

The SQL Server FLOOR Function is used to return the closest integer value which is less than or equal to given numeric value. The following query will show multiple ways to use FLOOR function.

T-SQL CODE

OUTPUT

ANALYSIS

Below lines of code is used to declare float variable and assigning the value.

In the below statement, We used FLOOR function to find the closest integer value of the variable @i (It means FLOOR(-208.45)). We also assigned new name to that result using SQL ALIAS Column.

In the next statement, We used the FLOOR Function directly on the float value.

In the below statement, We used the FLOOR Function directly on the multiple values.

It means

FLOOR (2.45 + 7.55 – 14.88)

FLOOR (-4.88) = – 5

SQL FLOOR Function Example 2

In this example, We are going to find the closet integer values for all the records present in [Service Grade] using FLOOR Function.

T-SQL CODE

OUTPUT

Thank You for Visiting Our Blog