Collections:
MOD() - Remainder of X divided by Y
How to calculate the remainder of X divided by Y using the MOD() function?
✍: FYIcenter.com
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.
⇐ MAKE_SET() - Filtering List with Binary Set
2023-11-15, 250🔥, 0💬
Popular Posts:
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...