General MySQL Oracle SQL Server

MOD() - Remainder of X divided by Y

Q

How to calculate the remainder of X divided by Y using the MOD() function?

✍: FYIcenter.com

A

MOD(X, Y) is a MySQL built-in function that calculates the remainder of X divided by Y. For example: 

SELECT MOD(253, 7), MOD(34.5, 3), MOD(2.6, 1.2);
  -- +-------------+--------------+---------------+
  -- | MOD(253, 7) | MOD(34.5, 3) | MOD(2.6, 1.2) |
  -- +-------------+--------------+---------------+
  -- |           1 |          1.5 |           0.2 |
  -- +-------------+--------------+---------------+

Reference information of the MOD() function: 

MOD(X, Y): val
  Returns the remainder of X divided by Y.

Arguments, return value and availability:
  X: Required. The dividend.
  Y: Required. The divisor.
  val: Return value. The remainder of the division.
  Available since MySQL 4.0.

 

⇒ PI() - Value of PI, π

⇐ MAKE_SET() - Filtering List with Binary Set

⇑ MySQL Functions on Numeric Values

⇑⇑ MySQL Function References

2023-11-15, 1362🔥, 0💬

General MySQL Oracle SQL Server