Which function is used to return remainder in a division operator in SQL?

by

The MOD function returns the remainder in a division operation.

In SQL, the function used to return the remainder in a division operation is the MOD function. The MOD function calculates the remainder of one number divided by another.

Here’s an example:

SELECT MOD(10, 3) AS Remainder;

In this example, the result would be 1 because 10 divided by 3 equals 3 with a remainder of 1.