Although the results returned by using these two functions are the same, it only means that the original records in the table can return the same result set by using these two functions.

Circular function

Returns a numeric value that is rounded according to the specified number of decimal places.

grammar

Round (expression [,numdecimalplaces])

Expression? Required parameters. The numeric expression to round. ?

numdecimalplaces？ Optional. Decimal numbers,

Represents the number of digits to the right of the decimal point when rounding.

If this parameter is omitted, the Round function will return an integer (including rounding to the nearest decimal).

INT function

Returns the integer part of the parameter, ignoring the decimal part of the number without rounding. In addition, if the number is negative, the INT function will return the first negative integer less than or equal to the number. For example, int will convert -8.4 into -9.

grammar

Int (number)

Parameter number is required.

The following chart list helps to understand the difference between these two functions. As for which function to choose, it depends on the actual demand.